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.

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 N875AMWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 36705 N875NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 33220 N876NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40767 N877NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31131 N878NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40768 N879NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31133 N87KBKkb Holdings LLC · Wilmington, DEBuilt 2003 · S/N 331 N880ECDodson International Parts Inc · Rantoul, KSS/N 56 N880NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40769 N881NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31135 N882NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 33221 N883GAFalcon Commercial Aviation LLC · Miami, FLBuilt 1988 · S/N 49710 N883NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31137 N884BBHf III LLC · Saint Paul, MNBuilt 1987 · S/N 17 N884NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33222 N885NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31139 N886NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33223 N887GARising Sun Aviation LLC · Irving, TXBuilt 1990 · S/N 49932 N887NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31141 N888WEPrime Aircraft & Aviation LLC · Edmond, OKS/N 394 N889NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33314 N890NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31143 N891NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33315 N892NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31145 N892QMMedina Iran · North Bay Village, FLS/N 078 N893NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33316 N894NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31147 N895NNWilmingtontrust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31149 N896NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 33224 N897NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 33318 N898NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33225 N899NNBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2012 · S/N 31151 N900BBNical Aviation LLC · Austin, TXBuilt 1999 · S/N 284 N900BKRck Aviation LLC · Woodside, CABuilt 2000 · S/N 187 N900DTega Air LLC · Bend, ORBuilt 1993 · S/N 131 N900EEIrish Air II LLC · Cincinnati, OHS/N 80 N900ERJdr 192 LLC · Woody Creek, COBuilt 2001 · S/N 192 N900KUFalcon 900-91 LLC · Lewes, DEBuilt 1991 · S/N 91 N900KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 53 N900LCMid Central Leasing LLC · Waukegan, ILBuilt 2000 · S/N 186 N900LPDoctair Inc · Mclean, VABuilt 1987 · S/N 20 N900MKRacer X LLC · Chicago, ILBuilt 1988 · S/N 40 N900MWGlobal Jet Partners LLC · Scottsdale, AZS/N 78 N900SBBg Air LLC · Hobbs, NMBuilt 1991 · S/N 107 N900SFFalcon 900 LLC · Mount Laurel, NJBuilt 1987 · S/N 16 N900TEFalcon 900 LLC · Ocala, FLBuilt 1986 · S/N 12 N900TNRegistered aircraftBuilt 1996 · S/N 158

Back to AD 99-23-22 R2