Skip to content

Registered aircraft · 549

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-05-21') 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-05-21') 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-05-21')
    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-05-21')
  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-05-21')
  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-05-21')
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.

N762CKKalitta Air LLC · Ypsilanti, MIBuilt 1992 · S/N 26236 N763CKKalitta Air LLC · Ypsilanti, MIBuilt 1993 · S/N 26233 N764CKKalitta Air LLC · Ypsilanti, MIBuilt 1994 · S/N 26234 N765CKKalitta Air LLC · Ypsilanti, MIBuilt 1992 · S/N 26238 N7672CBank Of Utah Trustee · Salt Lake City, UTS/N 30432 N7672DBank Of Utah Trustee · Salt Lake City, UTS/N 30433 N767AAramco Associated Co · Houston, TXBuilt 2003 · S/N 33685 N767AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22785 N77066United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29461 N78060United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29455 N781SNAtares Funding LLC · Fisher Island, FLBuilt 1998 · S/N 48781 N783SNAtares Funding LLC · Fisher Island, FLBuilt 1998 · S/N 48783 N797AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1985 · S/N 23147 N804MSInterface Operations LLC · Las Vegas, NVBuilt 1993 · S/N 27255 N804SNAtares Funding LLC · Miami Beach, FLBuilt 2000 · S/N 48804 N825MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29703 N826MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29713 N827MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29705 N828MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29699 N829MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29700 N830MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29701 N831MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29702 N832MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29704 N833MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29706 N834MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29707 N835MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29708 N836MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29709 N837MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29710 N838MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29711 N839MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29712 N840MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29718 N841MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29714 N842MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29715 N843MHDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29716 N844MHDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29717 N845MHDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29719 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 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 N922UPBoeing Co · Renton, WABuilt 2026 · S/N 68368 N923UPBoeing Co · Renton, WABuilt 2026 · S/N 68369

Back to AD 91-05-21