AD 2012-26-15
Registered aircraft · 5,558
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-26-15')
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-26-15')
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-26-15') 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-26-15') 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.
N11PHPegasus Wings LLC · Santa Monica, CAN11TSDevco Properties III LLC · Louisville, KYN1200KDelta Air Lines Inc · Atlanta, GAN1201PDelta Air Lines Inc · Atlanta, GAN12028American Airlines Inc · Fort Worth, TXN120AHWilmington Trust Co Trustee · Wilmington, DEN120DNDelta Air Lines Inc · Atlanta, GAN120EEUmb Bank Na Trustee · Salt Lake City, UTN120WLN120wl LLC · Del Mar, CAN1210NTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN1217AAndromeda Leasing I LLC · Purchase, NYN121ANBank Of Utah Trustee · Salt Lake City, UTN121DZDelta Air Lines Inc · Atlanta, GAN121QIq Worldwide Solutions LLC · Tampa, FLN121UWBank Of Utah Trustee · Salt Lake City, UTN1220ARivers End Ranch LLC · Lakeview, ORN1221GN1221g LLC · Fort Worth, TXN1227QFly Signature LLC · Newark, DEN1229AAndromeda Leasing I LLC · Purchase, NYN122AVase Corp V · Doral, FLN122DNDelta Air Lines Inc · Atlanta, GAN122GXFlan Air LLC · Flandreau, SDN122JMBuessli Aviation LLC · Menlo Park, CAN122NDAircraft Fidelity Corp Trustee · Dover, DEN122NNUmb Bank Na Trustee · Salt Lake City, UTN122PRHandshake Management LLC · San Rafael, CAN122USBank Of Utah Trustee · Salt Lake City, UTN122VRWest Texas Holdings LLC · San Antonio, TXN123DWDelta Air Lines Inc · Atlanta, GAN123NNUmb Bank Na Trustee · Salt Lake City, UTN123NXHeimdal Aviation LLC · Seattle, WAN123PDDooney & Bourke Inc · East Norwalk, CTN123SLSo Lucky One LLC · Wilmington, NCN123UWBank Of Utah Trustee · Salt Lake City, UTN1247EBozeman Technology Incubator Inc · Bozeman, MTN124AABank Of Utah Trustee · Salt Lake City, UTN124AMKeybank Na · Superior, CON124DXDelta Air Lines Inc · Atlanta, GAN124LTTurner Lyle C Trustee · Santa Barbara, CAN124N124 North LLC · Laguna Beach, CAN124PSDuck Pond Aviation II LLC · Livermore, CAN124RCutter Flight Management Inc · Albuquerque, NMN124USBank Of Utah Trustee · Salt Lake City, UTN125AABank Of Utah Trustee · Salt Lake City, UTN125BWBw Air LLC · Houston, TXN125DNDelta Air Lines Inc · Atlanta, GAN125QMed Air LLC · Lawrenceville, GAN125UWAmerican Airlines Inc · Forth Worth, TXN126ANBank Of Utah Trustee · Salt Lake City, UTN126BKAircraft Trust & Financing Corp Trustee · Wilmington, DE
Back to AD 2012-26-15