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.
N1423FSayers Carl D · Vidalia, LAN1423HSchneider Paul · Silverdale, WAN1423YStanger Eric R · Fernley, NVN1424DN1424d LLC · Collinsville, OKN1424FDutton Timothy F · Vassalboro, MEN1424KStarke Daniel L · Odessa, TXRegistration revokedN1424QPadilla Cresencio I · Big Spring, TXN1425BHicks Jason F · Denver, CON1425FHuarte Shawn D · Sammamish, WAN1426FMiller John T III · Greeneville, TNN1426QJr Imaging Logistics Inc · Pasco, WAN1426YIsmailyan Andre · Canoga Park, CAN1427DSheets George M · Tonkawa, OKN1427FHampton Stephen L · Culbertson, MTN1427HMolt Keaton V · Burns, ORN1428FPuttre John W · Sullivan, WIN1428HParrish Sidney J · Manley Hot Springs, AKN1429FLathrop Mark · Franklin, NCN1429QReeves Richard E · Lincoln, NEN1429VTeed Brad S · Vancouver, WAN1429YSemmig Jeffrey C · Oceanside, CAN142EZAttacoa Air LLC · Juneau, AKN142HBonser Thomas A · Cincinnati, OHN142LFFrench Lynn J · Broken Bow, NEN142MWStefenelli Aviation N-Tr Inc Trustee · AtterseeN142PDTj Air Holdings Inc Trustee · Wilmington, DEN142SBSopha Kim A · Poynette, WIN142VDakota Territory Air Museum · Minot, NDN1430BLutz Terry L · Williamston, MIN1430QGearhart Robert H · Three Rivers, MIN1430YSuess Matthew G · Rock City, ILN1431Bovee Timothy L · Wenatchee, WAN1431FAir Pirates Flying Club LLC · Virginia Beach, VAN1432BSpurgeon Michael R · Wrightwood, CAN1432FMcabee Patrick A · Tampa, FLN1432NSale Reported · Hooksett, NHSale reportedN1432YAll Sports Aviation LLC · Cocolalla, IDN1433DWenger Arthur B · Wickenburg, AZN1433FAnderson Jesse Thomas · Phoenix, AZN1433HCowley Curt J · Independence, ORN1434DWesner Philip F · Ashland, WIN1434FWinkelman Donald L · Anchorage, AKN1434YSky Hawk Partners LLC · Lugoff, SCN1435QWeaver G Thomas · Fairbanks, AKN1435YZipprich Robert A · Jacksonville, ILN1436DAsk Worldwide LLC · Ovid, MIN1436NKersten Adrian Lee · Anchorage, AKN14378Johnston Paul · Belleville, MIN1437FKelly William W · Springfield, ORN1437QPeyton Jerry L · Sebeka, MN
Back to AD 94-05-05 R1