Skip to content

Registered aircraft · 2,770

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:2018-20-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:2018-20-13') 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:2018-20-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:2018-20-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:2018-20-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:2018-20-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.

N17423Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67654 N17425Umb Bank N A Trustee · Salt Lake City, UTBuilt 2026 · S/N 66116 N17427Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67745 N17428Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67658 N17429Umb Bank N A Trustee · Salt Lake City, UTBuilt 2026 · S/N 67746 N17430Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 64450 N17431Umb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 43528 N17432Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 64451 N17433Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67747 N17435Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 64452 N17436United Airlines Inc · Chicago, ILBuilt 2026 · S/N 67748 N17437United Airlines Inc · Chicago, ILBuilt 2026 · S/N 43491 N17438United Airlines Inc · Chicago, ILBuilt 2026 · S/N 67668 N17441Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67670 N17443Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67672 N17444Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67721 N17448Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67674 N17452Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 43438 N17454Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 43441 N17455Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 62677 N17456Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67646 N17458Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 43444 N17459Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 43453 N17460Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67743 N17461Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67652 N17465United Airlines Inc · Chicago, ILBuilt 2026 · S/N 67657 N17467Wilmington Trust Co Trustee · Wilmington, DEBuilt 2026 · S/N 67659 N17468Wilmington Trust Co Trustee · Wilmington, DEBuilt 2026 · S/N 67660 N17475Wilmington Trust Co Trustee · Wilmington, DEBuilt 2026 · S/N 67666 N17477United Airlines Inc · Chicago, ILBuilt 2026 · S/N 67669 N17479Wilmington Trust Co Trustee · Wilmington, DEBuilt 2026 · S/N 67675 N17482Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67676 N17485United Airlines Inc · Chicago, ILS/N 67680 N17487United Airlines Inc · Chicago, ILS/N 67725 N17488United Airlines Inc · Chicago, ILS/N 67678 N17491Boeing Co · Renton, WAS/N 43498 N17493Boeing Co · Renton, WAS/N 43497 N17495Boeing Co · Renton, WAS/N 67683 N17496Boeing Co · Renton, WAS/N 67684 N17497Boeing Co · Renton, WAS/N 68762 N17499Boeing Co · Renton, WAS/N 67685 N174DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24802 N174DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29693 N174FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63105 N17529Wilmington Trust Co Trustee · Wilmington, DES/N 64503 N17550United Airlines Inc · Chicago, ILS/N 64479 N17557United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67584 N17564United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67188 N17565United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67186 N17566United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67185

Back to AD 2018-20-13