AD 99-08-13
Registered aircraft · 640
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:99-08-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-08-13')
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:99-08-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-08-13') 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.
N508KZWilmington Trust Company Trustee · Wilmington, DEN512JNAtares Funding LLC · Fisher Island, FLN513SNM48513 LLC · Esters, FLN534LAChirihue Leasing Trust · Wilmington, DEN536LAChirihue Leasing Trust · Wilmington, DEN537CAAc Spe 10 LLC · Orlando, FLN538LAQuetro Aircraft Leasing Trust · Wilmington, DEN540LACaiquen Leasing LLC · Wilmington, DEN542KDAtares Funding LLC · Fisher Island, FLN542LAQuetro Aircraft Leasing Trust · Wilmington, DEN543JNAtares Funding LLC · Fisher Island, FLN545JNAtares Funding LLC · Miami Beach, FLN546JNAtares Funding LLC · Fisher Island, FLN564LATagua Owner Trust · Wilmington, DEN566LAJilguero Owner Trust · Wilmington, DEN568LATagua Owner Trust · Wilmington, DEN570LATagua Owner Trust · Wilmington, DEN570UPUnited Parcel Service Co · Louisville, KYN571AZAmazon.Com Services LLC · Seattle, WAN572FEFederal Express Corp · Memphis, TNN572LATagua Owner Trust · Wilmington, DEN572UPUnited Parcel Service Co · Louisville, KYN573FEFederal Express Corp · Memphis, TNN573UPUnited Parcel Service Co · Louisville, KYN574FEFederal Express Corp · Memphis, TNN574UPUnited Parcel Service Co · Louisville, KYN575FEFederal Express Corp · Memphis, TNN576FEFederal Express Corp · Memphis, TNN576UPUnited Parcel Service Co · Louisville, KYN577UPUnited Parcel Service Co · Louisville, KYN578UPUnited Parcel Service Co · Louisville, KYN579UPUnited Parcel Service Co · Louisville, KYN580UPC C & E I LLC · Louisville, KYN581JNMobility Air LLC · Miami, FLN581UPC C & E I LLC · Louisville, KYN582FEFederal Express Corp · Memphis, TNN582UPC C & E I LLC · Louisville, KYN583FEFederal Express Corp · Memphis, TNN583UPUnited Parcel Service Co · Louisville, KYN584FEFederal Express Corp · Memphis, TNN585FEFederal Express Corp · Memphis, TNN586FEFederal Express Corp · Memphis, TNN587FEFederal Express Corp · Memphis, TNN588FEFederal Express Corp · Memphis, TNN589FEFederal Express Corp · Memphis, TNN59053United Airlines Inc · Chicago, ILN590FEFederal Express Corp · Memphis, TNN591FEFederal Express Corp · Memphis, TNN592FEFederal Express Corp · Memphis, TNN593FEFederal Express Corp · Memphis, TN
Back to AD 99-08-13