AD 2001-07-11
Registered aircraft · 472
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:2001-07-11')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-07-11')
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:2001-07-11') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-07-11') 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.
N255TKTurbine Aircraft Services LLC · Bethany, OKN257SJN257sj Aviation Corp · Middletown, DEN25BBPark Air LLC · Glendale, CAN25CYN25cy LLC · West Palm Beach, FLN25NYAndrews University · Berrien Springs, MIN25PWSolomon Mark Trustee · Wilmington, DEN260LFEthos Aviation LLC · Cleveland, OHN260RCValiair Limited Company Trustee · Casper, WYN263MSSueair Inc · Jacksonville, FLN264CKKalitta Charters LLC · Ypsilanti, MIN269HPJudd Air LLC · Escondido, CAN269JRAloft Aviation Services LLC · Spartanburg, SCN26ATDel Mar College · Corpus Christi, TXN26FNDodson International Parts Inc · Rantoul, KSN270JPLopez Fabio A · Denver, NCN277ALAti Jet Inc · El Paso, TXN277MKCasmos LLC · Wilmington, DEN278TTThunderun Aviation Corp · Buffalo, NYN27BJCbg LLC · Wilsonville, ORN285CTCf Aviation Trust LLC Trustee · Wilmington, DEN285DHRoyal Air Freight Inc · Waterford, MIN289AWAir Gato Enterprises Inc · Clearwater, FLN290CKKalitta Charters LLC · Ypsilanti, MIN292MEN292me LLC · Englewood, COFirst renewal noticeN293MCTechnical Education Services Inc DBA · Virginia Beach, VAN295CKKalitta Charters LLC · Ypsilanti, MIN295NWAmerican Trans Air T/A · Phoenix, AZN298CKKalitta 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, DEN304VSCalspan Corp · Buffalo, NYN30LJWorldwide Aircraft Services Inc · Tampa, FLN310PJN310pj LLC · Englewood, CON312LGJet Masters LLC · Englewood, CON312TLSterling Aircraft LLC · Anaheim, CAN3137Avstar Inc · Seattle, WAN314SGTvpx 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, MI
Back to AD 2001-07-11