AD 90-06-03 R1
Registered aircraft · 20,687
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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.
N8549UFauver Russell · Hartsville, SCN854ACKurchian Aram M · Sunland, CAN854AFAmeriflyers Of Texas Inc · Addison, TXN854EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN854GWCondair Flyers Inc · Latham, NYN854SCAlpha Charlie Aviation LLC · Keizer, ORN8551UFishman Randall · Napanoch, NYN8552BTenney Curtis J · Sevierville, TNN8553BVaught Ralph S · Star Valley, AZN8553UFinley Todd R · Carmel, INN8554BSummers Kim C · Winnemucca, NVN8554UWorkman David A · Putnam, ILN8555BThompson Greg M · Rigby, IDN8555ULeaf Sport LLC · Henning, MNN8556BKendig Dustin Zarah · Portland, ORN8557UOconnor Jonathan D · East Aurora, NYN8558BWilliams Ralph J · Essex Junction, VTN8558UNelson David R · Stanwood, WAN855CPVector Air LLC · Erie, CON855EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN8561USmith Michael V · Fort Myers, FLN8562UMall Craig S · Dingmans Ferry, PAN8563UCanupp Joseph J · Clinton, SCN8564BKarpe Kendall K · Plymouth, MNN8565BQuill James M · Granby, MAN8567UPfeiffer Rebecca M · Independence, MNN8568QSkyhawk Aero LLC · Montevideo, MNN8569BSpraches Edward J · Franklin, NCN856AUAuburn University · Auburn, ALN856EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN856FGRidgeline Assets LLC · Wilmington, DEN8570BPilot Coaches LLC · Little Falls, MNN8571UBell Charles M DBA · Warsaw, NYN8575UVermillion County Flying Club · Danville, ILN8576BRomeo Delta Inc · Elsie, MIN8579UStueckradt Steve · Ankeny, IAN857AUAuburn University · Auburn, ALN857SPSoutheastern Oklahoma State University · Durant, OKN8580BB&R Aircraft LLC · Wadsworth, OHN8580UBaker Shane A · Marshall, WIN8581ULarkin John · Cambridge, IDN8582BHousley William M · Jasper, ALN8582UMartin Livestock LLC · Ione, CAN8583UVon Burg Jon B · Hull, ILN8584VIdk Ventures LLC · Olympia, WAN8585UTreats Aviation Inc · Enumclaw, WAN8587BDorsey Tony A · Anchorage, AKN8587U172 Blue Wings LLC · Berwyn, PAN8588UNachio Aviation Services LLC · Tucson, AZN8589BHansen Aviation LLC · Savannah, GA
Back to AD 90-06-03 R1