AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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.
N8558UNelson David R · Stanwood, WAN85591Lucas Phillip J · West Sacramento, CAN8559GAeronautical Technical Service Inc · Collierville, TNN855JWButterfield Rory A · Milan, NMN855TWMapes Peter B · Oscoda, MIN85604Schmitz Cael D · Lebanon, MON8561GFox Harvey · Lititz, PAN8561USmith Michael V · Fort Myers, FLN8561XJ & K Flying LLC · Marengo, OHN85622Gunz Aviation LLC · Ridgeland, SCN8562UMall Craig S · Dingmans Ferry, PAN85633Hardy John R · Wasilla, AKN85634Wynia Steven P · Melba, IDN85636Corradi John M · Rixeyville, VAN8563JTschepen Leo R · Bisbee, NDN8563UCanupp Joseph J · Clinton, SCN85643Bas Part Sales LLC · Greeley, CON8564BKarpe Kendall K · Plymouth, MNN8565BQuill James M · Granby, MAN8565GFreedom Flight Service LLC · Glendale, AZN85668Seckerson Dale W · Jamestown, NDN8566EGermond Kyle P · Indianapolis, INN8566GEluwawalage Damayanthie · Reading, PAN8567UPfeiffer Rebecca M · Independence, MNN8568ECochran Brandon · Covington, GAN8568GSkeen Harry K · Philippi, WVN8568QSkyhawk Aero LLC · Montevideo, MNN85691Johnson Christopher N · West Richland, WAN8569BSpraches Edward J · Franklin, NCN856DMWendell Todd E · Axtell, NEN856DRSchreiber Ryan S · Winter Garden, FLN85705J Bird Air Service LLC · Cheyenne, WYN8570BPilot Coaches LLC · Little Falls, MNN8570GGreenville Pilots Association Eaa Chapter 1382 · Greenville, ILN85713Sky High LLC · Fort Defiance, VAN8571ESchwab Craig · Fort Walton Beach, FLN8571JRoam Gary A · Venice, FLN8571UBell Charles M DBA · Warsaw, NYN8571XRegistered aircraftN8572EFournier Louis W Jr · Ft Worth, TXN8572USkyline Aviation Solutions LLC · Grosse Ile, MIN8573GFichtner Eric Lowell Russell · Concord, NCN8574JHubenthal William L · Carbondale, ILN8574XDiscover Aviation Center LLC · Elyria, OHN85750Balzer Francis X · Paragon, INN85757Mann Joseph C · Cannon Falls, MNN8575EFreire Roberto F · Centerville, OHN8575GAero Services Lc · Woods Cross, UTN8575UVermillion County Flying Club · Danville, ILN8576BRomeo Delta Inc · Elsie, MI
Back to AD 94-05-05 R1