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.
N405KCS H S Corporation · Indianola, IAN406BKN406bk LLC · Nantucket, MAN406GAHyannis Air Service Inc · Hyannis, MAN406RCIsland Flights Inc · Wilmington, DEN4070LDesert Air LLC · Hagerman, NMN4074LEminent Technology · Tallahassee, FLN4078QGerker Carl J · Palmdale, CAN4079CCalled To Care Residential Facility LLC · Avondale, AZN407DMPhillips Consulting Group Inc · Wilmington, DEN4091GRobinson Brant Fitzgerald · Powder Springs, GAN409BKHyannis Air Service Inc DBA · Hyannis, MAN40GBSlb Enterprises LLC · Newark, DEN40MEUnlimited Boat Sales Inc · Page, AZN40PGFunanich Jon J Trustee · Fairfield, CAN40PMFlypie Industries LLC · Hudson, WIN40RUMoore Terry Alexander Trustee · Adel, GAN40SKSides Family Management LLC · El Paso, TXN40SSAdams Aviation Services Inc Trustee · Wilmington, DEN41019Sjs Flights Lp · Columbus, GAN4102LWiplinger Robert D · Inver Grove Height, MNN41041Mathews Christopher D · Blue Earth, MNN41055J&B Aircraft LLC · Anaheim, CAN41085421 Bravo LLC · Marine City, MIN410ABBloxsom Allan P III · Boerne, TXN410DRJmsat Corp · Moneta, VAN410ECSoutheast Enterprises LLC · Dothan, ALN410JCFbn Holding Corp · Larkspur, CAN410LJBednar David · Norwalk, IAN410NFMurphy Aviation Inc · Gilroy, CAN410PCBohnert Matthew · Bend, ORN410WMFlying Life LLC · Middleburg, FLN41106Delorenz Robert J · Boca Raton, FLN41114Iacobacci Timothy R · Fairborn, OHN4111SKnowles Warren R · Ocean City, NJN41124Wenta Nip & Sanitizing LLC · Monte Vista, CON4116GAcaats LLC · Queen Creek, AZN411ABAmerican Time Machine LLC · Edmond, OKN411DCWillert Fred J · San Diego, CAN411EGCompton William C · Anchorage, AKN411JGKern County Aviation Leasing LLC · Bakersfield, CAN411MZSongbird Air LLC · Lakewood, CON411STwin Adventures LLC · Cincinnati, OHN411TBLewis Nathan · North Plains, ORN411TTRambod Marc · Taos Ski Valley, NMN411VTvc Aviation Inc · Lebanon, OHN411VGMontala Investments LLC · Montgomery, ALN411ZJkdj LLC · Tyler, TXN4123TRace Dean · Chicken, AKN412BPMission Hardward Ltd Co · Savannah, GAN412CAAirswiss Inc · Wilmington, DE
Back to AD 75-09-13