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.
N287KMO'Connor Thomas F · Plano, TXN287TASivad Holdings Corp · Nacogdoches, TXN28835Waddingham William B · Rancho Cucamonga, CAN28913Bellas Business LLC · Kalispell, MTN28APAircraft Trust & Financing Corp Trustee · Wilmington, DEN28BRFlying Rock Aero LLC · Sunnyvale, CAN28CCGulf Airbatics Ltd · Jennings, LAN28JMWestern Aviation Services LLC · Cheyenne, WYN28LVCactus Clover Inc · El Paso, TXN28RHNational Airplane Sales & Leasing Corp · Lima, OHN28RSElohim Airparts Sales LLC · Naples, FLN29003R J Kielty Plumbing Heating And Cooling Inc · New Port Richey, FLN29084D E C Holdings · Hansen, IDN290CAHyannis Air Service Inc · Hyannis, MAN29113Figueroa Angel Lara · Winfield, ALN29138Allen Brent H · Mammoth Lakes, CAN29176Tgr Helicopters · Fresno, CAN29188Rugger Investment Group LLC · Tustin, CAN29190Mountain Helicopters LLC · Salt Lake City, UTN291RBAbbott Air Inc · Hydro, OKN29210Hawkes Brian R · Hamilton, MTN292RSValiair Limited Company Trustee · Casper, WYN293SMKemp Aviation LLC · Hiram, GAN29542Giannakakis Peter J · Monroe, MIN2957QGenerals International Inc · Red Oak, TXN295RJRegistered aircraftN2961JFrey Jerry P · Fallon, NVN29631Registered aircraftN29674Snflk Leasing LLC · Andrews, TXN2971QOn The Beam Aviation Inc · Hampton, GAN297ZEnovi LLC · Las Vegas, NVN299AOverman Robert W · Fairfield, OHN299GBHoodoo LLC · Missoula, MTN299KAir Transport LLC · Troy, MTN29BEAltaii Ali · Gibraltar, MIN29CCSafford Aviation Service Inc · Coolidge, AZN29RRKhg Aviation Holdings LLC · Columbus, OHN29XXMustang Aeronautics LLC · Chandler, AZN2KDElliott Frank F · Mojave, CAFirst renewal noticeN2LSNiec Steven M · Clio, MIN2RXJbs Enterprises LLC · Hamilton, MTN2SLLowe Aviation LLC · Bountiful, UTN2VRRead Andrew R · Milwaukee, WIN2VVAir Mods And Repair Inc · Robbinsville, NJN30038Stockyard LLC · Wilmington, DEN3008RPerguson Robert C · Converse, TXN300BDAircraft Inc · White Bear Lake, MNN300CGAircraft Guaranty Corp Trustee · Oklahoma City, OKN300HCPs Air LLC · Evansville, INN300MBIglesia De Cristo · Porter Ranch, CA
Back to AD 75-09-13