AD 2004-03-08
Registered aircraft · 330
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:2004-03-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-03-08')
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:2004-03-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-03-08') 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.
N220CKKalitta Charters LLC · Ypsilanti, MIN229LJN229lj LLC · Bentonville, ARN235LJMango Aviation Parts LLC · Plantation, FLN237CKKalitta Charters LLC · Ypsilanti, MIN239AYCavalljet Corp · The Woodlands, TXN239CASantiago Communities Inc · Orange, CAN239JCIbikunle Christopher · Dover, DEN240BThunderun Aviation Corp · Glenwood, NYN243JRDodson International Parts Inc · Rantoul, KSFirst renewal noticeN244LJN244lj Aviation Inc · Middletown, DEN244RG369ba LLC · West Columbia, SCN24NNWorld Jet Of Delaware Inc · Fort Lauderdale, FLN255TKTurbine Aircraft Services LLC · Bethany, OKN25BBPark Air LLC · Glendale, CAN260LFEthos Aviation LLC · Cleveland, OHN260RCValiair Limited Company Trustee · Casper, WYN264CKKalitta Charters LLC · Ypsilanti, MIN269HPJudd Air LLC · Escondido, CAN269JRAloft Aviation Services LLC · Spartanburg, SCN26FNDodson International Parts Inc · Rantoul, KSN277MKCasmos LLC · Wilmington, DEN278TTThunderun Aviation Corp · Buffalo, NYN289AWAir Gato Enterprises Inc · Clearwater, FLN290CKKalitta Charters LLC · Ypsilanti, MIN292MEN292me LLC · Englewood, COFirst renewal noticeN295CKKalitta Charters LLC · Ypsilanti, MIN298CKKalitta Charters LLC · Ypsilanti, MIN29SNRsb Investments LLC · Washington, PAN2FURed River/Adobe LLC · Dallas, TXN2SMMagnus Caro LLC · Alpine, WYN301EWAery Aviation LLC · Wilmington, DEN301NAAlliance Air Parts Acquisitions Corp · Oklahoma City, OKN302EWAery Aviation LLC · Wilmington, DEN30LJWorldwide Aircraft Services Inc · Tampa, FLN310PJN310pj LLC · Englewood, CON312LGJet Masters LLC · Englewood, CON312TLSterling Aircraft LLC · Anaheim, CAN314SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN317TTInter Island Yachts Inc · Zephyr Cove, NVN318NWMed Jets USA Inc · Boca Raton, FLN31DTFa31dt LLC · Owasso, OKN31EAAery Aviation LLC · Wilmington, DEN31GJGlobal Jetcare Inc · Brooksville, FLN31HKN31hk Inc · Miami, FLN31KHAery Aviation LLC · Wilmington, DEN31LJDelta November LLC · Lewes, DEN31RARoyal Air Freight Inc · Waterford, MIN31TKLear 31 Partners LLC · Edwards, CON31YAInternational Trading Energy Fuels LLC · Houston, TXN31ZVEzair International Leasing And Management Inc · Wilmington, DE
Back to AD 2004-03-08