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.

N804TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1989 · S/N 23988 N804XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61784 N805ALScashley Falcon LLC · Portland, MEBuilt 1988 · S/N 35 N805MLSmb Md-87 II LLC · Longwood, FLS/N 49777 N805NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31075 N805XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61785 N806NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29561 N806TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1992 · S/N 27081 N806WA53251 LLC · Miami Springs, FLBuilt 1991 · S/N 53251 N806XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61786 N807NNAmerican Airlines Inc · Fort Worth, TXS/N 31077 N807WAFederal Dynamics Corp · Henderson, NVBuilt 1993 · S/N 53093 N807XAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 63406 N808NANasa Neil A Armstrong Flight Research Center · Edwards, CABuilt 1984 · S/N 424 N808NNWilmington Trust Co Trustee · Wilmington, DES/N 33206 N808WACaribbean Sun Airlines Inc · Miami, FLBuilt 1990 · S/N 53044 N809NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33519 N809TARhoades Aviation Inc · Honolulu, HIBuilt 1987 · S/N 23796 N810NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 33207 N810TARhoades Aviation Inc · Honolulu, HIBuilt 1975 · S/N 21116 N811NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 31079 N811TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1986 · S/N 23538 N812NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33520 N812PMEl Jefe Express II LLC · Lake Forest, ILS/N 127 N813NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 30918 N813VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2009 · S/N 35353 N814NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29562 N815NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33208 N816AXBrookfield Reliable LLC · Kansas City, MOBuilt 1999 · S/N 285 N816NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31081 N817NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29558 N818NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 30910 N818VBPhoenix Air Group Inc · Cartersville, GABuilt 1980 · S/N 302 N819EXPreserve Air LLC · Honolulu, HIBuilt 2006 · S/N 347 N819NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 31083 N81HMIheart Media Management Services Inc · New York, NYBuilt 2000 · S/N 183 N820NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29559 N821AUBank Of Utah Trustee · Salt Lake City, UTS/N 24821 N821NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30912 N822NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31085 N823NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29560 N823SYSun Country Inc · Minneapolis, MNS/N 33971 N824NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30916 N824SMeregrass Inc · Dublin, TXBuilt 1987 · S/N 23 N824SYSun Country Inc · Minneapolis, MNBuilt 2005 · S/N 33976 N825AMWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 36699 N825NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31087 N825WKMadunn El LLC · Wayzata, MNBuilt 1980 · S/N 025 N826NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31089 N827NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33209

Back to AD 99-23-22 R2