AD 75-09-13
Registered aircraft · 4,787
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:75-09-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:75-09-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:75-09-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:75-09-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.
N5793XSchmick Kenneth Richard · Fond Du Lac, WIN57977Denney Dennis · New Port Richey, FLN57AMclallen Holdings LLC · Saint Charles, ILN57CXDmdt Ventures LLC · Victor, NYN57PBHyannis Air Service Inc DBA · Hyannis, MAN57TWBc & Tw Flying Service LLC · Hot Springs, ARN581CBColorado Baron LLC · Ketchum, IDN5825MLee Brian P · Kent, WAN5826CBank Of Utah Trustee · Salt Lake City, UTN5827MHopland Steve · Johnson City, TNN582SBHardy Gordon H · Belmont, CAN582TAWiday John P · El Cajon, CAN5843MEastern Aero LLC · Gibsonville, NCN584DSRose Michael · Prescott, AZN584MBCenterline Holdings Inc · Camden, DEN5858PMatherne David M · Houma, LAN5859MJasper County Properties LLC · Jasper, TXN5868CShimomura & Co Cpas Pc · New York, NYN5870MMcdonald Brian L · Van Alstyne, TXN5878MKodiak Helo LLC · Kodiak, AKN587GFReher David P · Arlington, TXN587MWHammonds Mark · N Richlnd Hls, TXN5889MKinney James R · Vermillion, SDN588TBVlot Cole T · Wellington, NVN589RBDukas Air LLC · Fort Lauderdale, FLN58BPN7ss LLC · Nashville, TNN58DFB727 LLC · Midland, TXN58DJPtc Financial Inc · Wilmington, DEFirst renewal noticeN58HBjk Aviation LLC · Morgantown, WVN58HDRoberts John E · Naples, FLN58JASunergy Solutions LLC · Londonderry, NHN58JDGrossman Kenneth R · Merced, CAN58JMLucky 7 Operating LLC · Many, LAN58LGMorgan Farms LLC · Twin Falls, IDN58LPPrichard Lev H · Dallas, TXN58MARagan Edwin E III · Austin, TXN58MDLicandro Rudolph · Prospect, KYN58PHangar Seven LLC · Penn Yan, NYN58PADwt Air LLC · Lakeland, FLN58PCGrooms David C · Gallatin, TNN58PDFoley Jeffrey William · Scappoose, ORN58PECenice LLC · Eagle, CON58PRQuinlan John H · Claxton, GAN58PZMiller Paul David · Dallas, TXN58RAGibbs Ron · Parker, AZN58TBTaylor Scott · Bg Bnd Ntl Pk, TXN58TCN58tc LLC · Gibsonton, FLN58TEGtk Services LLC · Carbondale, ILN58TFFlying Matters LLC · Cedarburg, WIN58TKTwa Partners LLC · Billings, MT
Back to AD 75-09-13