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.
N8576GSchaefer John · Liberty Hill, TXN8577GLakey Robert E · Arlington, TXN8578JParagon Aviation LLC · Reading, PAN8579UStueckradt Steve · Ankeny, IAN8580BB&R Aircraft LLC · Wadsworth, OHN8580UBaker Shane A · Marshall, WIN85817Lafleur Arthur W · Cuba, NYN8581ULarkin John · Cambridge, IDN8581XRegistered aircraftN8582BHousley William M · Jasper, ALN8582UMartin Livestock LLC · Ione, CAN8583UVon Burg Jon B · Hull, ILN8584JDarrach Todd I · Rhome, TXN8584VIdk Ventures LLC · Olympia, WAN8585GCollins Terry R · Lewistown, ILN8585UTreats Aviation Inc · Enumclaw, WAN8585XMcpeck Connor T · Gettysburg, SDN85870Allen Scott L · Ogallala, NEN85875Helms Christopher M · Durango, CON8587JMorgan Jeffrey E · Peebles, OHN8587U172 Blue Wings LLC · Berwyn, PAN8588GTulsa Technology Center School Dist No 18 · Tulsa, OKN8588JLyons Donald F · Cheverly, MDFirst renewal noticeN8588UNachio Aviation Services LLC · Tucson, AZN8589BHansen Aviation LLC · Savannah, GAN8589GRay Clinton R · Brighton, MIN858EMThompson Andrew M · Larimore, NDN858RBBurgess Darcie L · Muncie, INN8590GAsher Charles S · Grosse Ile, MIN8590USunrise Legacy Aviation LLC · Corona Del Mar, CAN8591BTechnical Education Services Inc T/A · Virginia Beach, VAN8592BCalvert John · Tybee Island, GAN8592UJls Construction & Mining Inc · Flagstaff, AZN8593BAndys Auto Sales LLC · Caroline, WIN8594BBeyer Jeffrey R · Slinger, WIN8594DWilliams Virgil R Jr · Monroe, GAN8595GLazy 8 Flying Service LLC · Polson, MTN8595UMoore James F Jr · Alexandria, KYN8596JNelson David D · Mercer, PAN8596UAtlanta Air Academy LLC · Kennesaw, GAN8597UMrd Aero LLC · Manheim, PAN8598UMcclay Andrew · Baker City, ORN8599BPruett Mike A · Springdale, ARN8599EPengilly Sky LLC · Ellicottville, NYN8599GBoatright Michael L · Live Oak, FLN85CNChabora Peter D · Brielle, NJN85CXKnapp Frank E · Palmer, AKN85EWBuehler Andrew C · Eatonville, WAN85GKSale Reported · Yonkers, NYSale reportedN85HSRegistration Pending · Steilacoom, WARegistration pending
Back to AD 94-05-05 R1