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.
N55RBGots To Go LLC · Wilmington, DEN55RXJs Enterprises LLC · Clarinda, IAN560BBSednal Enterprises · Los Gatos, CAN562DGB2d LLC · Wickenburg, AZN564RRAlpha Romeo Aviation LLC · Newark, DEN5655CRegistration Pending · Westford, MARegistration pendingN565RAN565ra LLC · Elbert, CON566AGarrett Flying Service Inc · Danbury, TXN567DEclipse Inc · Sharon Springs, KSN567DTCenturion Aviation Inc · Kalispell, MTN567KCWelch Darrnell M · Hillman, MIN567WAJasper Aviation Inc · Jasper, ALN5680CSea Spray Aviation LLC · New Smyrna Beach, FLN5688C5688c LLC · Glendale, AZN568HBKurreck Tim R · Caldwell, IDN568TWWestray James H · Gainesville, GAN5690CTailwinds Aircraft Holdings LLC · Harrisburg, NEN56CMFamily Practice Associates LLC · Ulysses, KSN56DCAero Services Lc · Woods Cross, UTN56GKMatan Kai LLC · West Hollywood, CAN56GLRainosek Kevin · Granbury, TXN56HDouble D International LLC · Miami, FLN56MAMinuteman Aviation Inc · Missoula, MTN56TJTrue North Aviation LLC · Leclaire, IAN56VPGoulette Bryan · Fort Worth, TXN5701XCoan Mark A · Berthoud, CON5714XKulon Andrew · Wyanet, ILN5716JTaos Sky Flight School LLC · El Prado, NMN5716XFlanegan Charles E Jr · Jonesboro, GAN5721XRichardson John L · Anchorage, AKN5729MN5729m LLC · Coral Springs, FLN5731XLife Is Flying Inc · Deerfield Beach, FLN5743JMidwest Aerial Photography · Galloway, OHN5746X300 Series Aviation LLC · Fort Worth, TXN5757CRoberts Justin · Livingston, MTN575SWHester Thomas F · Santa Barbara, CAN5762JJonesco Acquisitions LLC · Bixby, OKN5763MStan Hill Aviation LLC · Waterford, MIN5765MBush Abe A · Eatonton, GAN5768JHaag Walter G · Fall City, WAN5768S3c LLC · Waukee, IAN5769XHagemeier Justin · Memphis, TNN5770MBallard Aviation Inc · Newton, KSFirst renewal noticeN5779XDirigo Aerospace Solutions LLC · Sumner, MEN577CDSeger Properties Ltd · Fort Loramie, OHN577KBDavid A Bush Inc · Hanford, CAN577RJAviation Trust Company LLC · Oklahoma City, OKN5780XWilton William H · Kailua Kona, HIN5788XMcmahan William K · Sandy Valley, NVN5793MCoxbill Farms Inc · Torrington, WY
Back to AD 75-09-13