AD 2002-25-08
Registered aircraft · 661
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-25-08')
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-25-08')
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-25-08') 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-25-08') 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.
N251UPUnited Parcel Service Co · Louisville, KYN252FEFederal 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, KYN257FEFederal Express Corp · Memphis, TNN257UPUnited Parcel Service Co · Louisville, KYN258FEFederal Express Corp · Memphis, TNN258SNB29258 LLC · Estero, FLN258UPUnited Parcel Service Co · Louisville, KYN259FEFederal Express Corp · Memphis, TNN260FEFederal Express Corp · Memphis, TNN260UPUnited Parcel Service Co · Louisville, KYN261FEFederal Express Corp · Memphis, TNN261UPUnited Parcel Service Co · Louisville, KYN262FEFederal Express Corp · Memphis, TNN262UPUnited Parcel Service Co · Louisville, KYN263FEFederal Express Corp · Memphis, TNN263SGAtlas Air Inc · Purchase, NYN263UPUnited Parcel Service Co · Louisville, KYN264DEAircraft Endeavors LLC · San Antonio, TXN264FEFederal Express Corp · Memphis, TNN264UPUnited Parcel Service Co · Louisville, KYN265FEFederal Express Corp · Memphis, TNN265UPUnited Parcel Service Co · Louisville, KYN266FEFederal Express Corp · Memphis, TNN267FEFederal Express Corp · Memphis, TNN268FEFederal Express Corp · Memphis, TNN269FEFederal Express Corp · Memphis, TNN270FEFederal Express Corp · Memphis, TNN271CMCargo Aircraft Management Inc · Wilmington, OHN271FEFederal Express Corp · Memphis, TNN272FEFederal Express Corp · Memphis, TNN273FEFederal Express Corp · Memphis, TNN274FEFederal Express Corp · Memphis, TNN275FEFederal Express Corp · Memphis, TNN276FEFederal Express Corp · Memphis, TNN277FEFederal Express Corp · Memphis, TNN278FEFederal Express Corp · Memphis, TNN279FEFederal Express Corp · Memphis, TNN280FEFederal Express Corp · Memphis, TNN281FEFederal Express Corp · Memphis, TNN282FEFederal Express Corp · Memphis, TNN283CMCargo Aircraft Management Inc · Wilmington, OH
Back to AD 2002-25-08