AD 2012-04-05
Registered aircraft · 552
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-04-05')
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-04-05')
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-04-05') 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-04-05') 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.
N254UPUnited Parcel Service Co · Louisville, KYN255FEFederal Express Corporation · Memphis, TNN255UPUnited Parcel Service Co · Louisville, KYN256FEFederal Express Corp · Memphis, TNN256UPUnited Parcel Service Co · Louisville, KYN257FEFederal Express Corp · Memphis, TNN258FEFederal Express Corp · Memphis, TNN258SNB29258 LLC · Estero, FLN259FEFederal Express Corp · Memphis, TNN260FEFederal Express Corp · Memphis, TNN261FEFederal Express Corp · Memphis, TNN262FEFederal Express Corp · Memphis, TNN263FEFederal Express Corp · Memphis, TNN263SGAtlas Air Inc · Purchase, NYN264FEFederal Express Corp · Memphis, TNN265FEFederal Express Corp · Memphis, TNN266FEFederal 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, OHN283FEFederal Express Corp · Memphis, TNN284FEFederal Express Corp · Memphis, TNN285FEFederal Express Corp · Memphis, TNN286FEFederal Express Corp · Memphis, TNN287FEFederal Express Corp · Memphis, TNN288FEFederal Express Corp · Memphis, TNN289FEFederal Express Corp · Memphis, TNN290CMCargo Aircraft Management Inc · Wilmington, OHN290FEFederal Express Corp · Memphis, TNN291FEFederal Express Corp · Memphis, TNN292FEFederal Express Corp · Memphis, TNN293FEFederal Express Corp · Memphis, TNN294FEFederal Express Corp · Memphis, TNN295FEFederal Express Corp · Memphis, TNN296FEFederal Express Corp · Memphis, TN
Back to AD 2012-04-05