Skip to content

Registered aircraft · 3,204

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

N100GNFertitta Entertainment Holdings LLC · Houston, TXBuilt 2009 · S/N 6847 N100HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2025 · S/N 2291 N101DQDelta Air Lines Inc · Atlanta, GABuilt 2020 · S/N 9409 N101NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5834 N101VUAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 9039 N10248Aeroxs Inc · Swainsboro, GABuilt 1977 · S/N 1502 N102DNDelta Air Lines Inc · Atlanta, GABuilt 2020 · S/N 9485 N102HNAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 0159 N102NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5860 N102UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1998 · S/N 0844 N103DYUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 9538 N103MTMed Trans Corp · Denton, TXBuilt 2009 · S/N 9286 N103NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5884 N103USUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0861 N103VUAir Methods LLC · Greenwood Village, COS/N 9054 N1040NTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 1040 N104AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2021 · S/N 21016 N104DNUmb Bank Na Trustee · Salt Lake City, UTS/N 10009 N104NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5895 N104UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0863 N105DXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 10030 N105NKMed-Trans Corp · Denton, TXBuilt 2020 · S/N 9860 N105NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5904 N105UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0868 N106DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 10088 N106NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 5932 N107DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 9582 N107LCIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2007 · S/N 31074 N107NNUmb Bank N A Trustee · Salt Lake City, UTBuilt 2014 · S/N 5938 N107USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1052 N108DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10003 N108NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5946 N108UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1061 N108VUAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0509 N109BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 1999 · S/N 0139 N109DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 9588 N109DRBristow LLC · Lake Charles, LAS/N 31311 N109NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 5955 N109UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1065 N110ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5975 N110AWRegistered aircraftBuilt 2022 · S/N 21158 N110DXDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10015 N110GRAirbus Helicopters Inc · Grand Prairie, TXBuilt 2025 · S/N 21444 N110PKJet Midwest Inc · Kansas City, MOS/N 0054 N110SLAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 9302 N110UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1112 N111CXMojave Jet LLC · Nolensville, TNS/N 0711 N111DCDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10018 N111USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1114 N111ZMAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5983

Back to AD 2021-22-07