AD 75-05-01
Registered aircraft · 920
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:75-05-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-05-01')
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:75-05-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-05-01') 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.
N281FLInternational Trading Co Of Yukon · Oklahoma City, OKN289MTRaytheon Co · Ontario, CAN290FAUmb Bank N A Trustee · Salt Lake City, UTN29717United Airlines Inc · Chicago, ILN301KHAeko Kula LLC DBA · Honolulu, HIN301NWAmerican Airlines Inc · Fort Worth, TXN301PAAmerican Airlines Inc · Fort Worth, TXN302FLBank Of Utah Trustee · Salt Lake City, UTN303KHNas Aircraft Leasing Company LLC · Anchorage, AKN303TWLogistic Air Inc · Reno, NVN305NXAmerican Airlines Inc · Fort Worth, TXN306NYAmerican Airlines Inc · Fort Worth, TXN306PBAmerican Airlines Inc · Fort Worth, TXN307ACBank Of Utah Trustee · Salt Lake City, UTN309DEDelta Air Lines Inc · Atlanta, GAN309PCAmerican Airlines Inc · Fort Worth, TXN310DEDelta Air Lines Inc · Atlanta, GAN311GTUmb Bank Na Trustee · Salt Lake City, UTN313XAEastern 737 Asset Holdings LLC · Kansas City, MON314PDAmerican Airlines Inc · Fort Worth, TXN314XAEastern 737 Asset Holdings LLC · Kansas City, MON3159GUmb Bank Na Trustee · Salt Lake City, UTN315PEWilmington Trust Co Trustee · Wilmington, DEN3160GUmb Bank Na Trustee · Salt Lake City, UTN316PFAmerican Airlines Inc · Fort Worth, TXN317PGAmerican Airlines Inc · Fort Worth, TXN318FLUmb Bank Na Trustee · Salt Lake City, UTN322SGAtlas Air Inc · Purchase, NYN325FLUmb Bank Na Trustee · Salt Lake City, UTN326FLUmb Bank Na Trustee · Salt Lake City, UTN326TRTrans Executive Airlines Of Hawaii Inc DBA · Honolulu, HIN329ZAKalitta Air LLC · Ypsilanti, MIN330AEBank Of Utah Trustee · Salt Lake City, UTN331CKKalitta Charters II LLC · Ypsilanti, MIN33203United Airlines Inc · Chicago, ILN33209United Airlines Inc · Chicago, ILN33262United Airlines Inc · Chicago, ILN33264United Airlines Inc · Chicago, ILN33266United Airlines Inc · Chicago, ILN33284Umb Bank Na Trustee · Salt Lake City, UTN33286United Airlines Inc · Chicago, ILN33289United Airlines Inc · Chicago, ILN33292United Airlines Inc · Chicago, ILN33294Wells Fargo Trust Co Na Trustee · Columbia, MDN332CKKalitta Charters II LLC · Ypsilanti, MIN335PHAmerican Airlines Inc · Fort Worth, TXN33714United Airlines Inc · Chicago, ILN337JXJetonex LLC · Sunny Isles Beach, FLN337PJWilmington Trust Co Trustee · Wilmington, DEN338PKWilmington Trust Co Trustee · Wilmington, DE
Back to AD 75-05-01