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.

N197UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26901 N198PABartowjets LLC · Wilmington, DEBuilt 1986 · S/N 482 N2000Global Avionics LLC · Downey, CAS/N 56 N200GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 336 N200NVAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33341 N200WLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 352 N202PXZ & L Consulting LLC · Midland, TXS/N 17 N202WRDumont Associates Inc · Morris Plains, NJBuilt 1987 · S/N 24 N203NCC Aviation LLC · Maiden, NCBuilt 1990 · S/N 203 N209TRCareer Aviation Co Inc · Wilmington, DEBuilt 1976 · S/N 20994 N20GPN83 Charlie Inc · Fort Wayne, INBuilt 1992 · S/N 113 N211WGPentair LLC · Palmetto, FLBuilt 2006 · S/N 142 N213USMuseum Of Flight Foundation · Seattle, WABuilt 1969 · S/N 20213 N214DVRk-492 Leasing LLC · Miami, FLBuilt 2007 · S/N 350 N214FTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 300 N21723United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28790 N218EESolomon Mark Trustee · Wilmington, DEBuilt 1986 · S/N 489 N21HMIheartmedia Management Services Inc · New York, NYBuilt 1988 · S/N 41 N221CBFalcon 50ex 320 LLC · Miami Gardens, FLBuilt 2001 · S/N 320 N225PGAero 7 LLC · Doral, FLS/N 25247 N227LAK&A Advisors LLC · Wilmington, DEBuilt 1976 · S/N 193 N233KCMp Air LLC · Eagle Point, ORBuilt 1998 · S/N 48 N234LRDanish Jet Inc Trustee · Cheyenne, WYBuilt 1980 · S/N 300 N23707United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28768 N23708United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28769 N23721United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28940 N239AXAviation8 LLC · Carle Place, NYBuilt 1987 · S/N 39 N23FMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 296 N24089Ploutz Lloyd · Modesto, CAS/N 20455 N24202United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30429 N24211United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28771 N24212United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28772 N24224United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28933 N245ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35099 N24702United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28763 N24706United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28767 N24715United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28786 N24729United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28945 N24736United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28803 N247FRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 184 N248ACBank Of Utah Trustee · Salt Lake City, UTS/N E2364 N249BABoeing Aircraft Holding Co · Seattle, WAS/N 24309 N25201United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28958 N252QAQuality Aviation LLC · Boulder, COBuilt 2004 · S/N C-145 N253GCAerway Capital Management LLC · Waterford, WIS/N 25303 N25705United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28766 N25MXAce Parts LLC · Santa Fe Springs, CABuilt 1999 · S/N 182 N260ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 33597 N26208United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30580 N26210United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28770

Back to AD 99-23-22 R2