Skip to content

Registered aircraft · 1,335

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:99-23-22-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-23-22-R2') 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:99-23-22-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-23-22-R2')
  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:99-23-22-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-23-22-R2')
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.

N14240United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28952 N14242United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28805 N14249United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28809 N14250United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28957 N14704United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28765 N14731United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28799 N14735United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28950 N149XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1993 · S/N 27149 N14NAAnschutz Corp · Englewood, COBuilt 1992 · S/N 124 N150KMCcn Aircraft Holdings LLC · Portland, MES/N 62 N150RJ513 LLC · Newark, DEBuilt 2002 · S/N 324 N154TSFalcon Aviation Holdings LLC · Hawthorne, CABuilt 2002 · S/N 30515 N15710United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28780 N15712United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28783 N16217United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28777 N16234United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28946 N163PAN163pa LLC · Wilmington, DEBuilt 1982 · S/N 249 N164TSBank Of Utah Trustee · Salt Lake City, UTS/N 21119 N165TSBank Of Utah Trustee · Salt Lake City, UTS/N 21523 N16701United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28762 N16703United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28764 N16709United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28779 N16713United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28784 N16732United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28948 N171UAUnited Airlines Inc · Chicago, ILBuilt 1989 · S/N 24322 N17229Umb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 28793 N17233United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28943 N17244United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28954 N17245United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28955 N173PAN173pa LLC · Wilmington, DEBuilt 1982 · S/N 313 N175BGMile High Holdings LLC · Miami, FLBuilt 1983 · S/N 396 N17719United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28938 N17730United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28798 N17LKAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 431 N181RK330 Am Holding Corp · Miami, FLBuilt 1991 · S/N 515 N18220United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28929 N18223United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28932 N18243United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28806 N182UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25279 N183PASandy Wings LLC · Wilmington, DEBuilt 1984 · S/N 385 N184PABartowjets LLC · Wilmington, DEBuilt 1981 · S/N 318 N184SKBank Of Utah Trustee · Salt Lake City, UTS/N 28284 N18MZRegistration Pending · Aledo, TXRegistration pendingBuilt 1987 · S/N 32 N190PASandy Wings LLC · Wilmington, DES/N 320 N191NMcm Leasing LLC · Pittsfield, MABuilt 2003 · S/N 334 N192RSR&S Aviation Inc · Rancho Cucamonga, CABuilt 1995 · S/N 143 N194UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26892 N195PASandy Wings LLC · Wilmington, DEBuilt 1983 · S/N 399 N195UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26899 N196PASandy Wings LLC · Wilmington, DES/N 321

Back to AD 99-23-22 R2