AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N1756CGospel Ministries International Inc · Collegedale, TNN1756FHeistad Aviation Inc · Houston, TXN1756QVerhalen John P Jr · Scottsville, TXN1756RMontana Rose 185 LLC · Cornwall, VTN1757FAcker David Lynn · Eugene, ORN1757RKemna Barry J · Dallas, TXN1758UBas Part Sales LLC · Greeley, CON1758VKrickhahn Kermit O · Marion, TXN1759FOklahoma Flight Academy LLC · Owasso, OKN1759VFelbaum Jill E · Tecumseh, MIN175ASpencer Rimmel L · Haskell, OKN175AHAvonics LLC · Afton, WYN175AKRegistration Pending · Wasilla, AKRegistration pendingN175AMStevens Daniel · Oak Creek, CON175CBPr Aeronautics LLC · Buffalo, SDN175DHSegerstrom Ricky G Trustee · Grandview, TXN175EJudy Richard L · Beverly, WVN175FMark Kossler · Bozeman, MTN175FWWilfer Dennis · Fairbanks, AKN175GGoode Greg · Kalispell, MTN175JTViolette Randy · Manchester, MEN175JVDelta Charlie Aviation Services LLC · Culpeper, VAN175KAAir Cruiser LLC · New York, NYN175KBTvpx Ars Inc Trustee · North Salt Lake, UTN175MHall Nathan M · Palmer, AKN175MMHarden Jon R · Ijamsville, MDN175MTMeyer David A · Broomall, PAN175NSNovember Sierra Aviation LLC · Oneill, NEN175PBurdick Rich · Montrose, CON175PDD'Artenay Craig A · Coalinga, CAN175PPSchmidt Property Services LLC · Saint Peter, MNN175RBurdick Rich · Montrose, CON175RJSwanson Matthew I · Wasilla, AKN175SHSmith Edward · Lecompton, KSN175SMWhitley Steven · Auke Bay, AKN175SPN500aa LLC · Wilmington, DEN175TAAnderson Tracy E · Houston, TXN175TBSalyer Robert D · Nashville, TNN175TGMoschetti Flight Outfitters LLC · Kingston, WAN175THLa France Edward J · Ellensburg, WAN175TTFarrell Dolliver T · Sterling, AKN175TWSalyer Robert O · Nashville, TNN175UKChase Michael E Trustee · Montague, MIN175VCCashmere Aviation LLC · Mcalester, OKN175WRMcgraw Jeff M · Denver, CON1760FPark Rapids Avionics Inc · Park Rapids, MNN1760MCoggin Patric D · Fort Smith, ARN1761FTuttle Trent · Deforest, WIN1763MHaines Robert F · Carlsbad, CAN1763XRobins Nest Aviation LLC · Harrison, OH
Back to AD 97-01-13