AD 2004-22-01
Registered aircraft · 3,402
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:2004-22-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:2004-22-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:2004-22-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:2004-22-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.
N126ANBank Of Utah Trustee · Salt Lake City, UTN126DNDelta Air Lines Inc · Atlanta, GAN126UPC C & E I LLC · Louisville, KYN126UWAmerican Airlines Inc · Forth Worth, TXN127AABank Of Utah Trustee · Salt Lake City, UTN127DNDelta Air Lines Inc · Atlanta, GAN127HPHagerstown Aviation Museum Inc · Hagerstown, MDN127NKPerris Valley Airport Inc · Perris, CAN127UPUnited Parcel Service Co · Louisville, KYN127UWAmerican Airlines Inc · Fort Worth, TXN128ANBank Of Utah Trustee · Salt Lake City, UTN128DNDelta Air Lines Inc · Atlanta, GAN128UPUnited Parcel Service Co · Louisville, KYN128UWAmerican Airlines Inc · Fort Worth, TXN129AABank Of Utah Trustee · Salt Lake City, UTN129DNDelta Air Lines Inc · Atlanta, GAN129TWLogistic Air Inc · Reno, NVN129UPUnited Parcel Service Co · Louisville, KYN130ANBank Of Utah Trustee · Salt Lake City, UTN130UPUnited Parcel Service Co · Louisville, KYN13110United Airlines Inc · Chicago, ILN13113United Airlines Inc · Chicago, ILN13138United Airlines Inc · Chicago, ILN131NNBank Of Utah Trustee · Salt Lake City, UTN131UPUnited Parcel Service Co · Louisville, KYN1321AAndromeda Leasing I LLC · Purchase, NYN13227United Airlines Inc · Chicago, ILN13248Umb Bank Na Trustee · Salt Lake City, UTN132ANBank Of Utah Trustee · Salt Lake City, UTN133ANBank Of Utah Trustee · Salt Lake City, UTN133UPUnited Parcel Service Co · Louisville, KYN134ANBank Of Utah Trustee · Salt Lake City, UTN134UPUnited Parcel Service Co · Louisville, KYN135NNAmerican Airlines Inc · Fort Worth, TXN135UPUnited Parcel Service Co · Louisville, KYN136ANAmerican Airlines Inc · Fort Worth, TXN136FEFederal Express Corp · Memphis, TNN136UPUnited Parcel Service Co · Louisville, KYN13716United Airlines Inc · Chicago, ILN13718United Airlines Inc · Chicago, ILN13720United Airlines Inc · Chicago, ILN13750United Airlines Inc · Chicago, ILN137AAAmerican Airlines Inc · Fort Worth, TXN137ARWyatt Aerospace LLC · Chandler, AZFirst renewal noticeN137UPUnited Parcel Service Co · Louisville, KYN1381AMsn 27615 LLC · Purchase, NYN138ANAmerican Airlines Inc · Fort Worth, TXN138FEFederal Express Corp · Memphis, TNN138UPUnited Parcel Service Co · Louisville, KYN1399AAndromeda Leasing I LLC · Purchase, NY
Back to AD 2004-22-01