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.
N9223VQuick Janice L · Wrightwood, CAN9223WPierce Construction LLC · Shelby, ALN9223XDhs Operations LLC · Wilmington, DEN92247World Class Aviation Ltd · Bellefontaine, OHN9224DAlleman Mark J Inc · Wilmington, DEN9224JJackson Jonathan · Siloam Springs, ARN9224LAnalytical Technologies Inc · Miami, FLN9224NBlanchard Aviation LLC · Nazareth, PAN9224VBevington Carl R · Middle Point, OHN9224WOppermann K Edward · Kingwood, TXN92255Kloker Daniel E · Owasso, OKN92258Mendez Leonel Jr · Corpus Christi, TXN9225CMeriden Aviation Center LLC · Meriden, CTN9225LTerry Mark B · Henderson, NCN9225MSmith Carl L · Danville, KYN9225NOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLFirst renewal noticeN9225VDuncan Mark E · Marlton, NJN9225WMosley Marvin C · Buckley, WAN92264Dhs Operations LLC · Wilmington, DEN92266Dhs Operations LLC · Wilmington, DEN9226CLane Community College · Eugene, ORN9226DClf Industries LLC · Thornton, CON9226FLewis University · Romeoville, ILN9226HDebt LLC · Yuma, AZN9226SSpencer Montgomery L · Clinton, SCN9227JBinns George E · Hackettstown, NJN9227MMullis Brent S · Garfield, GAN9227WMasterman Robert David · Chugiak, AKN9228DLavender James R · Gainesville, TXN9228JHail State Aviation LLC · Madison, MSN9228LRegistered aircraftN9228MSteubs Mike H · Portland, ORN9228NEncore Jet Management LLC · San Antonio, TXN9228VDuval James A · Lima, OHN92296Raymes Billy F · Stedman, NCN9229BSsb Holdings LLC · Lake Wales, FLN9229CNoble Land & Cattle Inc · Albion, NEN9229DStevens Mark F · Ocean Springs, MSN9229FCooke John W III · Carthage, TXN9229JUnterschuetz Phillip David · Ladysmith, WIN9229MMadsen Jan Eric · Lincoln, NEN9229SRegistered aircraftN9229WShackelford John S Jr · Roanoke, TXN922AKSanderson David C · Fort Davis, TXN922CTSweptwing Holdings LLC · Houston, TXN922DDHillsboro Aero Academy LLC · Hillsboro, ORN922EAButler Ronald A · Cumming, GAN922ESSpears Esten W · Ocala, FLN922KDDoughty Robert M · Earlville, ILN922LHClover Park Technical College · Lakewood, WA
Back to AD 81-18-04 R2