AD 95-07-01
Registered aircraft · 43,396
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:95-07-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-07-01')
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:95-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-07-01') 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.
N1031XJj Byrne International Inc · Steamboat Springs, CON10329Lissow William M · New Port Richey, FLN1032JKornegay Kenneth D · Roanoke, VAN1032SThurber Matthew Calbraith · Vancouver, WAN10339Yarbro Floyd A · Kenton, TNN1033CHuson Lee E · Port Townsend, WAN1033TManzo Deborah S · Lake Placid, FLN1034XBlasa Randy · Bowling Green, FLN1035XSocal Blue Side Up LLC · Anaheim, CAN1036JPremier Jets Inc · Hillsboro, ORN1036LN1036l Corp · Wilmington, DEN1036NKovaleski Thomas J · Chugiak, AKN1036XMotley Douglas Trustee · Rehoboth Beach, DEN10375Tactical Turtle LLC · Ortanna, PAN1037JTate Andrew E · Chapel Hill, NCN1038JLandgraf Robert J · Sussex, WIN1038NSome Beech LLC · Bolivar, MON1039JN1039j LLC · Casa Grande, AZN1039MManly James H · Reno, NVN1039PN1039p LLC · Suwanee, GAN1039UIowa Lakes Community College · Estherville, IAN103AASmith George Barker · Lexington, KYN103ACKrueger Douglas K Trustee · Aurora, NEN103ARHd Outdoor Advs LLC · Coalgate, OKN103ASHill Bryan Thomas · Page, AZN103ATWjm Aviation LLC · Bridgeville, PAN103AVFlying To Infinity And Beyond LLC · Atlanta, GAN103BBHarris John F III · Louisburg, NCN103BCPalmer David M · Jacksonville, ORN103BHBeck Randy R · Claremont, CAN103BUColorado Aircraft Corp · Watkins, CON103CTSocolosky Stephen Gerard · East Hartford, CTN103DJChicoine Chris · Williston, VTN103EAJwp Group LLC · Long Island, MEN103ENKjs Development LLC · Temecula, CAN103FVChristiansen Aviation LLC · Wilmington, DEN103GLNaylor Aviation LLC · Columbia, MON103HPMcfarland Natalie · Roseburg, ORN103HYLegend Flyer LLC · Bozman, MDN103KCLang Elmer N · Hemphill, TXN103KFCsa Aircraft Leasing LLC · Salt Lake City, UTN103LULynn University Inc · Boca Raton, FLN103MPJoyce George E · Franklinville, NCN103MRDeepvine Partners LLC · Simonton, TXN103NCState Of North Carolina · Raleigh, NCN103PZRaging Thermal Sky Sports LLC · Brighton, CON103RGTupelo Aeronautics Inc · Tupelo, MSN103RRLancaster Flyers LLC · Fenwick Island, DEN103RSZielke Michael M · Chuluota, FLN103SJBarnick Air Holdings LLC · Santa Barbara, CA
Back to AD 95-07-01