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.
N248FEFederal Express Corp · Memphis, TNN249BABoeing Aircraft Holding Co · Seattle, WAN249FEFederal Express Corporation · Memphis, TNN24KTFalcon Type Air LLC · Nashville, TNN250FEFederal Express Corp · Memphis, TNN250UPUnited Parcel Service Co · Louisville, KYN251AZCargo Aircraft Management Inc · Wilmington, OHN251FEFederal Express Corp · Memphis, TNN251UPUnited Parcel Service Co · Louisville, KYN25201United Airlines Inc · Chicago, ILN252FEFederal Express Corp · Memphis, TNN252UPUnited Parcel Service Co · Louisville, KYN253FEFederal Express Corp · Memphis, TNN254FEFederal Express Corp · Memphis, TNN254UPUnited Parcel Service Co · Louisville, KYN255CMCargo Aircraft Management Inc · Wilmington, OHN255FEFederal Express Corporation · Memphis, TNN255UPUnited Parcel Service Co · Louisville, KYN256FEFederal Express Corp · Memphis, TNN256UPUnited Parcel Service Co · Louisville, KYN257AZCargo Aircraft Management Inc · Wilmington, OHN257FEFederal Express Corp · Memphis, TNN257UPUnited Parcel Service Co · Louisville, KYN258FEFederal Express Corp · Memphis, TNN258SNB29258 LLC · Estero, FLN258UPUnited Parcel Service Co · Louisville, KYN259FEFederal Express Corp · Memphis, TNN25EGGarcia Airways LLC · Virginia Beach, VAN25VRr Aero LLC · Carson City, NVN260FEFederal Express Corp · Memphis, TNN260UPUnited Parcel Service Co · Louisville, KYN261FEFederal Express Corp · Memphis, TNN261UPUnited Parcel Service Co · Louisville, KYN26208United Airlines Inc · Chicago, ILN26210United Airlines Inc · Chicago, ILN26215United Airlines Inc · Chicago, ILN26226United Airlines Inc · Chicago, ILN26232United Airlines Inc · Chicago, ILN262FEFederal Express Corp · Memphis, TNN262UPUnited Parcel Service Co · Louisville, KYN263FEFederal Express Corp · Memphis, TNN263SGAtlas Air Inc · Purchase, NYN263UPUnited Parcel Service Co · Louisville, KYN264FEFederal Express Corp · Memphis, TNN264GVCsc Delaware Trust Co Trustee · Wilmington, DEN264UPUnited Parcel Service Co · Louisville, KYN265FEFederal Express Corp · Memphis, TNN265UPUnited Parcel Service Co · Louisville, KYN266FEFederal Express Corp · Memphis, TNN267FEFederal Express Corp · Memphis, TN
Back to AD 2002-22-12