AD 81-18-04 R2
Registered aircraft · 81,733
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N921CTN921ct LLC · Elkton, KYN921DCCarlson Donald A III · Lexington, TNN921EZAircraft Guaranty Corp Trustee · Oklahoma City, OKN921GDAir Charter Inc DBA · Culebra, PRN921JKShackleford Wayne D · Riverside, CAN921JMFlight Equity LLC · Fayetteville, ARN921KCRocket City Helicopters LLC · Brownsboro, ALN921KPCenturion N709jm LLC · Minneapolis, MNN921LCCrum Robert W · Lake Havasu City, AZN921LGHertz David · Dix Hills, NYN921LJGossett Chase · Centre, ALN921NDUniversity Of North Dakota · Grand Forks, NDN921PABird Acquisition LLC · Phoenix, AZN921PCProppe Karl H · Needham, MAN921RCCall Raymond T · Batesville, INN921RSSpry Mark W · Elkmont, ALN921SJDavis Brandon Grey · Huntsville, ALN921TAAtp Aircraft 4 LLC · Wilmington, DEN921TCBell Charles S · Fort Payne, ALN921TTRed Baron LLC · Middletown, DEN921UTumbleweed Leasing Co Inc · Salt Lake City, UTN921WC7 Corp · Orlando, FLN921WJJones Wesley C · Yuba City, CAN921XPLengler Aviation LLC · Fort Myers, FLN922Tjk Enterprises LLC · Helena, MTN9220BSchmalenberger Jason R · Hebron, NDN9220CDixon Aviation LLC · Oakland, MDN9220DEllis Harvey Airport Inc · Guthrie, OKN9220MBeaty David · Santa Fe, NMN9220SWard Jessica · Southport, NCN9221DOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLN9221JJgms Rose LLC · Stamford, CTN9221WWadi-Ramahi Shadi J · Evansville, INN92228Dhs Operations LLC · Wilmington, DEN9222DMatthews David C · Fairbanks, AKN9222HDhs Operations LLC · Wilmington, DEN9222LTyler Timothy C · Wyoming, OHN9222QGood Shepherd Leasing Corp · Brooksville, FLN9222RWellman A Ryan · San Jose, CAN9222SSvendsen James · Center Moriches, NYN9222VSoco Scuba LLC · Austin, TXN9222WJohnson Michael E · Tyler, TXN92236Garfoot William K · Verona, WIN92239Kingdom Air LLC · Kalispell, MTN9223CDhs Operations LLC · Wilmington, DEN9223EDhs Operations LLC · Wilmington, DEN9223FMckeeman Kevin · Abilene, KSN9223HHallock Robert C III · Sag Harbor, NYN9223JRudo Mark R · Milton, DEN9223LHogan Fredrick C · Oviedo, FL
Back to AD 81-18-04 R2