AD 2012-06-17
Registered aircraft · 284
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-06-17')
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-06-17')
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-06-17') 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-06-17') 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.
N447JFN447jf LLC · New Hudson, MIN448QSNji Sales Inc · Oklahoma City, OKN44GJN44gj LLC · Camden, DEN44GVN44gv LLC · Pacific Palisades, CAN450ABBlue Vista LLC · Newport Beach, CAN450BGT Champsions Houston LLC · Dallas, TXN450BTTw Aviation LLC · Jupiter, FLN450BWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN450CEBlue Flag Two Ltd · Miamisburg, OHN450DTAll Island Charter LLC · Woodbury, NYN450FKAircraft T&F LLC Trustee · Wilmington, DEN450FXService Electric Co · Cleveland, OHN450GAGulfstream Leasing LLC · Savannah, GAN450GGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN450JCSunshine State Capital Management LLC · Naples, FLN450JSDjb Aviation LLC · Hackensack, NJN450LMillard Management Company LLC · Omaha, NEN450LRRicotta Lance · Yuma, AZN450LVKendall Road Pegasus LLC · Chicago, ILN450MEPopping Up Everywhere LLC · Las Vegas, NVN450MHRegistered aircraftN450PDKag Services LLC · Meridian, IDN450PUAstra Holdings Inc · Wilmington, DEN450QSNji Sales Inc · Oklahoma City, OKN450SMJohn R Miller Enterprises V LLC · Salt Lake City, UTN450VAJe Air LLC · Corona Del Mar, CAN450VMTtx 2 LLC · Las Vegas, NVN450WBBindley Aviation LLC · Indianapolis, INN450WCPark Landing Aviation LLC · Madison, NJN450XXJmjmac Holdings LLC · Miramar, FLN451BHHerd Michael A · Tyler, TXN451FXLmt Illumination LLC · Cleveland, OHN452FXMj Travel Enterprises LLC · Cleveland, OHN453FXFlexjet LLC · Cleveland, OHN454FXFlexjet LLC · Cleveland, OHN455FXKotzubei Jacob · Cleveland, OHN455KHRegistered aircraftN455QSDodson International Parts Inc · Rantoul, KSN456CPGs 450 Partners LLC · Atlanta, GAN456FXFlextjet LLC · Cleveland, OHN457FXFlexjet LLC · Cleveland, OHN457MPTesoro Aviation Co · Findlay, OHN458FXNylife LLC · Cleveland, OHN459FXDab-Jab Air LLC · Cleveland, OHN459MPBank Of Utah Trustee · Salt Lake City, UTN45DPBank Of Utah Trustee · Salt Lake City, UTN460AKTangier Services LLC · Mill Valley, CAN460FXFlexjet LLC · Cleveland, OHN461FXGfi Acquisitions LLC · Cleveland, OHN461QSDodson International Parts Inc · Rantoul, KS
Back to AD 2012-06-17