Skip to content

Registered aircraft · 465

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

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:91-13-10-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-13-10-R1') ORDER BY n_number

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:91-13-10-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-13-10-R1')
  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:91-13-10-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-13-10-R1')
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.

N744AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22221 N744CKKalitta Air LLC · Ypsilanti, MIBuilt 1993 · S/N 26353 N745AXCargo Aircraft Management Inc · Wilmington, OHS/N 22222 N745CKKalitta Air LLC · Ypsilanti, MIBuilt 1998 · S/N 26361 N7470Museum Of Flight Foundation · Seattle, WABuilt 1969 · S/N 20235 N747GFGe Engine Leasing Holdings Inc · Cincinnati, OHBuilt 1994 · S/N 26355 N747SFAerospace Trust Management LLC Trustee · Wilmington, DES/N 21575 N749AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 22226 N750AXBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 22227 N752AXAeroacq Partners LLC · Laud By Sea, FLS/N 23434 N756CAAc Spe 4 LLC · Orlando, FLBuilt 1991 · S/N 26547 N760CKKalitta Air LLC · Ypsilanti, MIBuilt 1990 · S/N 24753 N761CKKalitta Air LLC · Ypsilanti, MIBuilt 1989 · S/N 24752 N761CXCargo Aircraft Management Inc · Wilmington, OHBuilt 1985 · S/N 22318 N766CKKalitta Air LLC · Ypsilanti, MIBuilt 2005 · S/N 34016 N7672CBank Of Utah Trustee · Salt Lake City, UTS/N 30432 N7672DBank Of Utah Trustee · Salt Lake City, UTS/N 30433 N7673CCsds Asset Management LLC · Rllng Hls Est, CAS/N 28264 N767AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22785 N767BZBank Of Utah Trustee · Salt Lake City, UTS/N 22567 N767CKKalitta Air LLC · Ypsilanti, MIBuilt 2005 · S/N 34017 N767MWWyatt Aerospace LLC · Chandler, AZBuilt 1982 · S/N 22694 N768AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22786 N768CKKalitta Air LLC · Ypsilanti, MIS/N 34018 N768VACargo Aircraft Management Inc · Wilmington, OHBuilt 1982 · S/N 21869 N773AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22788 N774AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22789 N780BABoeing Aircraft Holding Co · Renton, WABuilt 1990 · S/N 24310 N783AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 23016 N783CKKalitta Air LLC · Ypsilanti, MIBuilt 1990 · S/N 24782 N787CKKalitta Air LLC · Ypsilanti, MIBuilt 1997 · S/N 28838 N793AXAeroacq Partners LLC · Laud By Sea, FLS/N 23143 N797AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1985 · S/N 23147 N829WWHemisphere Aerospace Investments LLC · Waco, TXS/N 27503 N858FTLogistic Air Inc · Reno, NVBuilt 1970 · S/N 20109 N903ARUmb Bank Na Trustee · Salt Lake City, UTBuilt 2002 · S/N 33096 N904ARUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 33097 N905NANational Aeronautics And Space Administration · Houston, TXBuilt 1970 · S/N 20107 N910UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67980 N912UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67981 N913UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67982 N914UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67983 N915UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 67984 N916UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 67985 N917UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68363 N918UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68364 N919CAAc Spe 2 LLC · Orlando, FLBuilt 1991 · S/N 25302 N919UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68365 N920UPBoeing Co · Renton, WABuilt 2026 · S/N 68366 N921UPBoeing Co · Renton, WABuilt 2026 · S/N 68367

Back to AD 91-13-10 R1