AD 2002-22-12
Registered aircraft · 2,065
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:2002-22-12')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-22-12')
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:2002-22-12') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-22-12') 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.
N21723United Airlines Inc · Chicago, ILN217JCSouthwest Airlines Co · Dallas, TXN218WNSouthwest Airlines Co · Dallas, TXN219CYCargo Aircraft Management Inc · Wilmington, OHN219WNSouthwest Airlines Co · Dallas, TXN220WNSouthwest Airlines Co · Dallas, TXN224WNSouthwest Airlines Co · Dallas, TXN225AXOmni Planes LLC · Tulsa, OKN225NE2/25/94 LLC · Foxboro, MAN225WNSouthwest Airlines Co · Dallas, TXN226WNSouthwest Airlines Co · Dallas, TXN227AZCargo Aircraft Management Inc · Wilmington, OHN227CYCargo Aircraft Management Inc · Wilmington, OHN227WNSouthwest Airlines Co · Dallas, TXN228WNSouthwest Airlines Co · Dallas, TXN229AZCargo Aircraft Management Inc · Wilmington, OHN229WNSouthwest Airlines Co · Dallas, TXN231WNSouthwest Airlines Co · Dallas, TXN232CEN232ce LLC · Newberry, FLN232TAAviation Trading Partners LLC · Shawnee, KSN232WNSouthwest Airlines Co · Dallas, TXN233AZCargo Aircraft Management Inc · Wilmington, OHN234AXCargo Aircraft Management Inc · Wilmington, OHN234WNSouthwest Airlines Co · Dallas, TXN236WNSouthwest Airlines Co · Dallas, TXN23707United Airlines Inc · Chicago, ILN23708United Airlines Inc · Chicago, ILN23721United Airlines Inc · Chicago, ILN237CMCargo Aircraft Management Inc · Wilmington, OHN239AZCargo Aircraft Management Inc · Wilmington, OHN24089Ploutz Lloyd · Modesto, CAN240MCN240mc LLC · Watertown, SDN2411APuerto Rico Air Management Services Inc · Coral Gables, FLN241AZCargo Aircraft Management Inc · Wilmington, OHN24202United Airlines Inc · Chicago, ILN24211United Airlines Inc · Chicago, ILN24212United Airlines Inc · Chicago, ILN24224United Airlines Inc · Chicago, ILN244ALDodson International Parts Inc · Rantoul, KSN244FEFederal Express Corp · Memphis, TNN245FEFederal Express Corp · Memphis, TNN246FEFederal Express Corp · Memphis, TNN246JLJog068 Inc · Lewes, DEN246QTArctic One LLC · Fairbanks, AKN24706United Airlines Inc · Chicago, ILN24715United Airlines Inc · Chicago, ILN24729United Airlines Inc · Chicago, ILN24736United Airlines Inc · Chicago, ILN247FEFederal Express Corp · Memphis, TNN248ACBank Of Utah Trustee · Salt Lake City, UT
Back to AD 2002-22-12