AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-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:2012-10-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:2012-10-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:2012-10-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.
N504CSBeach Cruiser Express LLC · Hummelstown, PAN504FPBaumgarten Jeffrey A · New Orleans, LAN504GLBravo Whiskey Solutions LLC · Brenham, TXN504HXTes Aircraft Leasing LLC · Fort Myers, FLN504JLJade Management Inc · Hailey, IDN504JWPalmer Gary H · San Juan, TXN504LAircraft Holding Solutions LLC Trustee · Newark, DEN504LMLucky H Farms Inc · Mesa, WAN504PGHlm Partners LLC · Grosse Pt Shr, MIN504TBAutomotive Air III LLC · Belcamp, MDN504TKN504tk LLC · Fairhope, ALN5050GHats Off Aviation LLC · Newnan, GAN5050MMarijune Aviation LLC · Lakeland, FLN5056XN5056x LLC · Troy, OHN505ACPark Creek Holdings LLC · Quanah, TXN505ARDoss Justin · Beaumont, TXN505CDValiair Limited Company Owner Trustee · Casper, WYN505CNLes Amis Air LLC · Dorado, PRN505FRAf Holdings LLC · Argyle, TXN505JTSheffels Eric B · Wayland, MAN505MAMonmouth Aviation LLC · Sea Girt, NJN505MBAr South Aviation LLC · Lafayette, LAN505PCRegistered aircraftN505PGNorthern Minnesota Group LLC · Baxter, MNN505PTBeckett Consulting Services Inc · Fort Collins, CON505SFLux William E · Newman Lake, WAN505TSOms Aviation LLC · Boise, IDN505WMAndrew Aircraft Sales LLC · Selmer, TNN5060VMacair Aviation LLC · Xenia, OHN5061QLepper Michael J · Ward, CON5062HCoati Aviation LLC · San Diego, CAN5065RZ J Express LLC · Lewes, DEN506CPHunter Mechanical & Controls Inc · Oklahoma City, OKN506LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN506LR5m Aviation Holdings LLC · Monticello, FLN506PGPegasus Air LLC · Westerville, OHN5072CThomas Robert Allan Jr · Phoenix, AZN5073CInternational Air Services Inc Trustee · Carson City, NVN5075YAlkota Of Kansas LLC · Wichita, KSN507CPFrom The Ground Up Air LLC · Lake Havasu City, AZN507HHGrossetete Nugget S · Edgewood, NMN507KBTj Air Holdings Inc Trustee · Wilmington, DEN507MCBowden Wayne · Draper, UTN507NANasa Langley Research Center · Hampton, VAN507RWSmith Air LLC · Bentonville, ARN5080RRodriguez Roberto F · Tampa, FLN5081EGolden Alan · Wilmette, ILN5083JKrs Aerial Inc · Galloway, OHN5083TClaar Brian · Spring, TXN5083WJtc Investments LLC · Tyrone, GA
Back to AD 2012-10-13