AD 94-05-05 R1
Registered aircraft · 26,232
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.
N65SUSky West Aviation Inc Trustee · Albuquerque, NMN65WBMckamey Robert S · Tullahoma, TNN66006Registration Pending · Souderton, PARegistration pendingN66009Cowan Ronnie C · Glasgow, KYN6600DMarsh John E · Washington, DCN6600FSeiger Thomas W · Medford, ORN6600NNaber David L · Fairbanks, AKN6600TJtf Aviation LLC · River Falls, WIN66017Engelhardt John · Kingwood, TXFirst renewal noticeN6601EBiloff Chet A · Palmer, AKN6601THoting John M · Santa Rosa, CAN66022Pickett Ronald K II · Mc Alpin, FLN6602FBeasley Thomas · Fort Worth, TXN6603AWise Phillip L · Harris, MON6603ERequa Kerry E · Twin Falls, IDN6603FAres Andrey · Fort Lauderdale, FLN6603NStellon O'Donnell Thomas J · Fairbanks, AKN6603SColonial Air Inc · New Bedford, MAN66042Hudson Steven E · Junction City, KSN66047Shiles Darrell J · Baltimore, MDN6604AFlight Club LLC · Dover, DEN6604HBarnstormer Squadron Aviation J-3 LLC · Mesa, AZN6604NBakken Carl S · Kettle Falls, WAN6604TGrimes Matthew K · Norman, OKN66054Wooten Jeffrey B · Rock Hill, SCN66055Tas Aviation Aircraft Sales LLC · Defiance, OHN6605AKehoe Troy D · Bridgeport, TXN6605ESmith Daniel · Kingsland, TXN66063Taylor Jonathon K · Carlsbad, CAN66064Radford Lawrence · Scottsdale, AZN66069Vintage Wings Aircraft LLC · Centerpoint, INN6606AMckenna Terence M · Scotts Valley, CAN6606GRoach Georgia L · Dewitt, ARN66073Jenkins Jerome D · Gays Mills, WIN66075Malachi Israel · Superior, WIN66077Johnson Jerry L · Lewiston, IDN66079Dacy Patrick J · Huntley, ILN6607AOlson Duane C · Columbus, KSN6607EHoly Cow Flying Club · Fairbanks, AKN6607FRegistered aircraftN66086Barbosa Manuel Moreira · Apple Valley, MNN66088James M Carrigan LLC · Sanibel, FLN66089Powell Brett · Bennett, CON6608AMarquardt Ashley F · Anchorage, AKN6608EMans David A · Spearman, TXN6608NBooth James L · Bozeman, MTN66092Grinberg Dmitry · Austin, TXN66093Ponderosa Land Surveys LLC · Lead, SDN66094Nelson Harry L · Towner, NDN66099Maddock Jay A · Sugar Grove, IL
Back to AD 94-05-05 R1