AD 75-09-05
Registered aircraft · 371
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-05')
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-05')
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-05') 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-05') 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.
N200BJWright Thomas L · Clyde, OHN211EWJtb Logistics LLC · Byars, OKN2125XMathews Wade · Wichita Falls, TXN212PMEllisor Don · Grapeland, TXN2131XBrown Jerry D · Rockport, TXN2138XSpencer Douglas J · Greenwood, CAN2139XAerometrix LLC · Lino Lakes, MNN2168XOrtiz Stewart Flynn · San Diego, CAN2186XAshiku Phillip · Ukiah, CAN2192XGoldsmith Alejandro J · Houston, TXN2200XPowell George · Locust Grove, GAN2216XSouthern Aircraft Consultancy Inc Trustee · Casper, WYN2222XOrtiz Stewart Flynn · San Diego, CAN2224XRegistered aircraftN222LJDodson International Parts Inc · Rantoul, KSN2238XStyron Mark A · Pasadena, TXN2240XTri-Rotor Spray & Chemical · Ulysses, KSN2243XSmith Debra A · Louisville, KYN2244XPlane Life LLC · Wilmington, DEN2255XProp & Jet Air Museum Inc · Romoland, CAN2256XPoole Douglas G · California, MDN2262XStampfler Richard D · Groveland, MAN2266XBarney Julius C · Lutz, FLN2267XRound Engine Aero · Nashville, MIN2271XSantaska Inc · Palmer, AKN2273XAll Florida Recovery Corp · Palm Coast, FLN2274XDutko Adam M · Elyria, OHN2279XSander Farms Inc · Wilmington, DEN2284XWilson Gregory S · Cairo, MON2290XMatthews Roy E · Sparta, MIN2294XCsc Delaware Trust Co Trustee · Wilmington, DEN2299XSturgeon Keith A · Saginaw, TXN22CMDavis Frederich K · Dunbar, PAN22MDHolland Bryan K · Sterling, AKN22PNLingle Gordon D · Gun Barrel City, TXN2332SLouisiana Military Museum · Abbeville, LAN2344SAnderas Per R · Green Bay, WIN2345SSummers Jeffrey L · Pekin, INN2362SMclaren Institute Of Transporation Technologies · Goode, VAN2366SDaughtrey Kevin E · Arcadia, FLN2382SMielczarek Joe I · Santa Paula, CAN2397SState Of Wisconsin · Madison, WIN2413SQualitair LLC Trustee · MichelstadtN2417SPiasecki Aircraft Corporation · Coatesville, PAN243MBSwanson Timothy J · Bannister, MIN246BTGentile Keith · Riverton, UTN2474SEllison William K · Tipton, INN2486SDarvek LLC · Las Vegas, NVN2491SGeorge Ladelle L · Ashley, NDN24DCCraig Joshua · Bonaire, GA
Back to AD 75-09-05