AD 2015-02-13
Registered aircraft · 383
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:2015-02-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:2015-02-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:2015-02-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:2015-02-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.
N831AEBank Of Utah Trustee · Salt Lake City, UTN832HKCbg LLC · Wilsonville, ORN833AEBank Of Utah Trustee · Salt Lake City, UTN835HKCbg LLC · Wilsonville, ORN836AECorporate Flight Management Inc DBA · Smyrna, TNN837AEBank Of Utah Trustee · Salt Lake City, UTN838AEBank Of Utah Trustee · Salt Lake City, UTN840AEBank Of Utah Trustee · Salt Lake City, UTN842AEBank Of Utah Trustee · Salt Lake City, UTN842HKAerovision Aircraft Services LLC · Muskegon, MIN846AECorporate Flight Management Inc DBA · Smyrna, TNN848AEBank Of Utah Trustee · Salt Lake City, UTN849AEBank Of Utah Trustee · Salt Lake City, UTN850AEBank Of Utah Trustee · Salt Lake City, UTN852AEBank Of Utah Trustee · Salt Lake City, UTN853AECorporate Flight Management Inc DBA · Smyrna, TNN856AEAvi Sales & Leasing Services LLC · Muskegon, MIN857AEDelux Public Charter LLC · Dallas, TXN861BBCorporate Flight Management DBA · Smyrna, TNN87VAAdvanced Air LLC · Statesville, NCN89LDMckee Foods Transportation LLC · Collegedale, TNN900AEAmerican Airlines Inc · Fort Worth, TXN902BCAmerican Airlines Inc · Fort Worth, TXN905JHAmerican Airlines Inc · Fort Worth, TXN906AEAmerican Airlines Inc · Fort Worth, TXN907AEAmerican Airlines Inc · Fort Worth, TXN908AEAmerican Airlines Inc · Fort Worth, TXN909AEAmerican Airlines Inc · Fort Worth, TXN912JXDelux Public Charter LLC · Dallas, TXN913JXDelux Public Charter LLC · Dallas, TXN914JXDelux Public Charter LLC · Dallas, TXN915JXDelux Public Charter LLC · Dallas, TXN916JXDelux Public Charter LLC · Dallas, TXN917JXDelux Public Charter LLC · Dallas, TXN918AEAmerican Airlines Inc · Fort Worth, TXN918JXDelux Public Charter LLC · Dallas, TXN919JXDelux Public Charter LLC · Dallas, TXN922AEAmerican Airlines Inc · Fort Worth, TXN922JXDelux Public Charter LLC · Dallas, TXN923AEAmerican Airlines Inc · Fort Worth, TXN925AEAmerican Airlines Inc · Fort Worth, TXN926FMRvr Air Charter LLC · Fort Worth, TXN926JXDelux Public Charter LLC · Dallas, TXN928AEAmerican Airlines Inc · Fort Worth, TXN928JXDelux Public Charter LLC · Dallas, TXN92VAAdvanced Air LLC · Statesville, NCN931AEAmerican Airlines Inc · Fort Worth, TXN931JXDelux Public Charter LLC · Dallas, TXN932AEAmerican Airlines Inc · Fort Worth, TXN932JXDelux Public Charter LLC · Dallas, TX
Back to AD 2015-02-13