Skip to content

Registered aircraft · 5,443

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

N2884DThree Wing Flight School LLC · Stratford, CTBuilt 1979 · S/N 28-7916504 N2884LPurdue Aviation LLC · West Lafayette, INBuilt 1979 · S/N 28-7916507 N2884XAngle Of Attack Flying Company LLC · Springfield, MOBuilt 1979 · S/N 28-7916511 N28852Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843732 N2885BIxi LLC · West Bloomfield, MIS/N 28-7916513 N2885DLehigh Valley Flying Club Inc · Lehigh Valley, PABuilt 1979 · S/N 28-7990520 N2885FDunkly Daniel L · Chico, CABuilt 1979 · S/N 28-7990521 N2885GWisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 28-8090001 N2885KDierkes Steven P · Henderson, NVBuilt 1979 · S/N 28-7990525 N2885MGuilford Lakes Aviation LLC · Greensboro, NCS/N 28-7990526 N2885NBrandy Wine Flight School · West Chester, PAS/N 28-7990527 N2886KTallman George L Jr · Ocala, FLBuilt 1979 · S/N 28-7990529 N2886XMiller Robert Joseph · Fence Lake, NMBuilt 1979 · S/N 28-7990530 N28887Danos Laura S · Hampton Falls, NHBuilt 1979 · S/N 28-7990432 N28890Slocum Chad W · Pleasant Grove, UTS/N 28-7990433 N288BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881751 N288CBCalifornia Baptist University · Riverside, CABuilt 2023 · S/N 2881635 N288HGGeorgia Aviation Authority · Eastman, GABuilt 2002 · S/N 2842144 N288HPChaikin Steven · Kaunakakai, HIBuilt 2001 · S/N 2843482 N288PASkywest Leasing Inc · St George, UTBuilt 2002 · S/N 2843502 N28907Warren Scott D · Lucerne, CABuilt 1979 · S/N 28-7990434 N28926Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881233 N2893CChapel Hill Flying Club DBA · Sanford, NCS/N 28-7916517 N2893LKhalaf Maher · Canton, MIBuilt 1979 · S/N 28-7916520 N2893MRls Rental Co Inc DBA · Joplin, MOBuilt 1977 · S/N 28-7816321 N2893ZElite Aviation Of The Carolinas LLC · Tobaccoville, NCS/N 28-7990533 N28949Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881257 N2894BBarthell Burley O · Saint Johns, FLS/N 28-7990535 N2894MHernandez Michael A · Stockton, CABuilt 1977 · S/N 28-7816322 N28958Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881258 N28959Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881259 N28978Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881280 N28979Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881282 N2897MInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 28-7816323 N289BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881752 N289HGGeorgia Aviation Authority · Eastman, GABuilt 2002 · S/N 2842146 N289HPLemon And Black LLC · Raleigh, NCBuilt 2003 · S/N 2843544 N289NDLoyd Fred Wayne · Rossville, GABuilt 2000 · S/N 2844039 N289PAGenn Tx LLC · Farmersville, TXBuilt 2002 · S/N 2844065 N289STSml Aviation LLC · Parker, COBuilt 2018 · S/N 2881039 N28AUAndrews University · Berrien Springs, MIBuilt 2014 · S/N 2843781 N28DTSilverstreak Aviation LLC · The Villages, FLBuilt 2002 · S/N 2843534 N28JAJersey Aero Club Inc · Lakewood, NJBuilt 1982 · S/N 28-8290137 N28KUIal Corp · Lewes, DES/N 2881142 N28MBMockingbird Flying Club Inc · Sioux Falls, SDBuilt 1980 · S/N 28-8090292 N28NSMockingbird Flying Club · Sioux Falls, SDBuilt 1976 · S/N 28-7790227 N28PGLane Community Colleg · Eugene, ORBuilt 1979 · S/N 28-7916405 N28PPPiper Aircraft Inc · Vero Beach, FLBuilt 2019 · S/N 2881041 N28RInternational Air Services Inc Trustee · Carson City, NVBuilt 1994 · S/N 2890202 N28STParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020129

Back to AD 2016-07-21