Registered aircraft · 11,798

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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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.

N872DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31983 N872FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0200 N872NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 33219 N872WHTheologos Charles · Waveland, MSBuilt 1993 · S/N TH-1679 N87386Golden Eagle Flyers Inc · Cheyenne, WYS/N 421C0168 N873AFDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1984 · S/N BB-1200 N873DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31984 N873FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0202 N873JDBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N TH-2044 N873NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40766 N873WHG & A Viation LLC · Miller, MOBuilt 1993 · S/N TH-1680 N874AAAntares Aviation LLC · Boca Raton, FLBuilt 1978 · S/N 21386 N874DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31985 N874FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0205 N874JETc Air LLC · Williamson, WVS/N TH-2045 N874NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31129 N874SPSamaritans Purse · Boone, NCBuilt 1981 · S/N BB-874 N874WHRed Oak Aviation LLC · Sunset, LABuilt 1993 · S/N TH-1681 N87507United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31637 N87512United Airlines Inc · Chicago, ILBuilt 2008 · S/N 33458 N87513United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31621 N87527United Airlines Inc · Chicago, ILBuilt 2010 · S/N 38701 N87531United Airlines Inc · Chicago, ILBuilt 2011 · S/N 39999 N87541Chadbourne Daniel I Jr · Anchorage, AKS/N 421C0007 N87561Forest Aire LLC · Flagstaff, AZBuilt 1975 · S/N 421C0017 N875AMWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 36705 N875BRenson Travel LLC · San Antonio, TXBuilt 2013 · S/N FL-875 N875DBDbco LLC · Greenwood Village, COBuilt 1980 · S/N TH-1135 N875DMKilo Alfa 200 LLC · Bakersfield, CABuilt 1990 · S/N BB-1354 N875DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31986 N875FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0206 N875JGN875jg LLC · Lawton, OKS/N TH-2046 N875MRMarc Aircraft Holding LLC · Soldotna, AKBuilt 2009 · S/N 208B2079 N875NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 33220 N875PDGarmin International Inc · Olathe, KSS/N E-3534 N875SPPacific Mission Aviation · Hagatna, GUBuilt 1975 · S/N BB-86 N87699Pjh Consulting LLC · Reno, NVBuilt 1981 · S/N BB-887 N876ATTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N BB-931 N876DNDelta Air Lines Inc · Atlanta, GAFirst renewal noticeS/N 31987 N876FEFederal Express Corporation · Memphis, TNS/N 208B0207 N876JATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 560-5048 N876MSAvoboe LLC · North Little Rock, ARBuilt 2015 · S/N 525-0876 N876NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40767 N876PAPax.Dei LLC · Hot Springs, ARBuilt 1977 · S/N LJ-757 N876PMGeddie Steven Gwynn · College Station, TXBuilt 1976 · S/N E-961 N876UStewart James G Trustee · Pacifica, CABuilt 2018 · S/N 525-0997 N8778Ligon Air LLC · Birmingham, ALBuilt 2001 · S/N 258560 N877CAHausman Benjamin · Merritt Island, FLBuilt 1994 · S/N TH-1727 N877DNDelta Air Lines Inc · Atlanta, GAFirst renewal noticeBuilt 2017 · S/N 31988 N877HLLeavitt Randall Stephen Trustee · San Diego, CABuilt 1991 · S/N E-2643

Back to AD 2006-16-18 R1