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.
N5324JSouthern Aircraft Consultancy Inc Trustee · Casper, WYN5325YBeehive Telephone Co Inc Nevada · Lake Point, UTN5328JKahler Automation Corp · Fairmont, MNN532CHall Brian · Yuma, AZN532CHWhedbee Donald Justin · Conroe, TXN532EBJeb Air LLC · Waverly, OHN5337CMarc Inc · Bolton, MSN5337YClement Aviation Inc · Tea, SDN5338AThompson Richard T · Wilmington, OHN5338UWatermelon Packer Ll · Mcallen, TXN53391Schwend Brian · Forsyth, MTN533ACEast Tennessee Aviation Services LLC · Harrison, TNN533STGentry Air LLC · Orlando, FLN533WPJacobs Aviation LLC · Mt Juliet, TNN5340GLegal Limit Motor Sports LLC · Anderson, CAN5340WHebel Ryan · North Potomac, MDN5340YCripe Michael L · San Luis Obispo, CAN5346JCsc Delaware Trust Co Trustee · Wilmington, DEN5348UC3 Shadow LLC · Columbus, OHN5348YWheeler Robert T · Silt, CON5358UMadson Chris · King City, CAN5359APalo Duro Aircraft Services Lc · Mckinney, TXN535CRScs Assets LLC · Ponce, PRN535MESky West Aviation Inc Trustee · Albuquerque, NMN5362AFerguson Lynn D · Alpine, WYN5365XSale Reported · Greeley, COSale reportedN5368AValiair Limited Co Trustee · Casper, WYN5369YPollard William Edward · Big Spring, TXN536JSShoffner James P Jr · Denver, CON5370JJaaam Skyline Inc · Middletown, DEN5371JColeair LLC · Lewes, DEN5372CFlc Aviation LLC · Dyersburg, TNN5383ASummers Timothy P · Rincon, GAN5386ATriplett And Adams Transport Partnership LLC · New Concord, OHN5391ASingh Amandeep · Stockton, CAN5394XL K Hollenbeak Logging Inc · Hayfork, CAN5395VCortez Flying Service Inc · Cortez, CON53AUJoachim Peter · Grafton, WIN53MG28 Lv LLC · Las Vegas, NVN53MJAviation Hangar Foam Specialists LLC · Tucson, AZN53RRTwo Romeos LLC · Pasco, WAN53WTRock House LLC · Keizer, ORN5401AHeadon Richard · Chino Hills, CAN5401XBarbera Frank M · Edgewood, NMN5402AHodge Marcus · Mansfield, LAN5404WBas Part Sales LLC · Greeley, CON5405AN5405a LLC · Beverly Hills, CAN5409GRichland Aviation Inc · Sidney, MTN5409YLee Christopher · Katy, TXN540CEEverel Airborne LLC · Sandia Park, NM
Back to AD 75-09-13