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.
N444RWBackus Gary Carl · Chesapeake, VAN444SRr&D Lp · Fayetteville, NCN444SMPosada Law Pllc · Boca Raton, FLN444TAMiller Conner · Lake Havasu City, AZN444VPBalzer Joseph W · Sevierville, TNN4458SCn Aviation LLC · Mesa, AZN445HPChopra Family Lp · Tulare, CAN446MMInternational Air Services Inc Trustee · Carson City, NVN4486WReynolds Eric Eugene · Weatherford, TXN448BBHawkflight LLC · Sugar Land, TXN448JDavenport James A · San Antonio, TXN4492UAircraft & Aviation Professionals LLC · Coldwater, MIN449LLPlane Fun Inc Tr Trustee · Snellville, GAN44CCoyne Greg · Hondo, TXN44ECN44ec LLC · Caddo Mills, TXN44EEEchemann Thomas A · Sidney, OHN44GAFly Qts LLC · Oconomowoc, WIN44HALaps LLC · Elkhorn, WIN44HRCardinal Aviation Services LLC · Castle Rock, CON44KFEbert Construction Co Inc · Wamego, KSN44KRMcilhenny Edward A · Clayton, GAN44NTTucker Nicholas B · La Canada, CAN44SAGniks LLC · Nevada, MON44SCAir Charter Solutions Inc · Bloomington, MNFirst renewal noticeN44WHKelly Sean R · Bozeman, MTN44XJRegistered aircraftN4500KEaston Gregory D · Montrose, CON4500VBales Philip J · Chandler, AZN4509JHill Curtis E · Bancroft, IDN450CSCbcb Aircraft LLC · Colfax, WAN4522KGoodman Jack A · Memphis, TNN4528JRobertson Crop Dusting Service Inc · South Haven, MIN4533JStevens Investment Group LLC · Elsie, MIN4537QInstant Security Service Inc · Wilmington, DEN4547SLorentz Aviation LLC · Canadian, TXN454RBDan Cox LLC · Troutdale, ORN454SPSps Investment Properties LLC · Macon, GAN4557NWestra Aviation LLC · Beaver Dam, WIN455JRHinaa Hidaa LLC · Chino Valley, AZN455RHanusin Mark J · Huntley, ILN455SDJ&L Aviation LLC · Malta, NYN455TBSmith Loren D · Great Falls, MTN455XTreat-Yo-Self Confections Inc · Corona, CAN4560KRegistered aircraftN4566MPalacios Luis A · El Paso, TXN4568NBergren Scott W Trustee · Walnut Creek, CAN456ATBonanza Aircraft Lc · Steamboat Springs, CON456BRPressurized LLC · Sequim, WAFirst renewal noticeN456BWCustom Wholesale Supply Co Inc · Odessa, TXN456JMLandmark Aviation Services LLC · Sarasota, FL
Back to AD 75-09-13