Registered aircraft · 47,138

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:2000-23-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:2000-23-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:2000-23-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:2000-23-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:2000-23-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:2000-23-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.

N2879KTwo Niner Kilo LLC · Seattle, WABuilt 1979 · S/N 18053115 N2879WEvenson Paul S · Grant, MNBuilt 1979 · S/N 28R-7931239 N2879YDawson Ronald Dwight Sr · Garland, TXBuilt 1987 · S/N 28R-7931240 N287AACirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11647 N287CPAlves Philip · Sandy, UTBuilt 2008 · S/N 3225 N287DSCustis Cirrus Aviation LLC · Birmingham, ALS/N 2156 N287HHaught Herbie B Jr · Mountain View, ARBuilt 1965 · S/N D-7763 N287JBQ&A Holdings LLC · Elkridge, MDBuilt 2003 · S/N 001 N287JGGully John F · Brooklyn, NYBuilt 1965 · S/N CD934 N287JTA W Aviation · Sevierville, TNBuilt 1953 · S/N G-287 N287KMO'Connor Thomas F · Plano, TXBuilt 1980 · S/N TJ-330 N287LMDjc Bonanza LLC · Stuart, FLBuilt 1994 · S/N E-2859 N287TCAiv Con Inc · Charlevoix, MIBuilt 1969 · S/N 18260183 N287THTh Aviation LLC · Savannah, GABuilt 2019 · S/N 4807 N2880RPhelps Thomas J · Orem, UTBuilt 1967 · S/N 18258480 N2880YRegistered aircraftBuilt 1962 · S/N 18253880 N2881FAirplanes Over Niagara LLC · Lewiston, NYBuilt 1966 · S/N 18256981 N2881MJones James N · Missoula, MTBuilt 1977 · S/N 28R-7803153 N2882WWholey James · Saratoga, CABuilt 1973 · S/N E-452 N2882YVx Aviation LLC · Palisade, COBuilt 1962 · S/N 18253882 N2883RCallegari Sergio P · Reno, NVBuilt 1967 · S/N 18258483 N2884ADowns M Todd · De Leon, TXFirst renewal noticeBuilt 1953 · S/N 30084 N2884FTurner Michael B · Covington, TNBuilt 1966 · S/N 18256984 N2884KJ Robert Finley And Associates Inc · Mountain Home, ARBuilt 1979 · S/N 18053118 N2884RSalem Coastal Enterprises LLC · Elizabeth City, NCFirst renewal noticeBuilt 1967 · S/N 18258484 N2884YTri-Aviation Inc · Amarillo, TXBuilt 1962 · S/N 18253884 N2885YMiner Bradford Aviation LLC · Spanish Fork, UTS/N 18253885 N2886FWeldon Larry W · Titusville, PABuilt 1966 · S/N 18256986 N2886WBushong Chistopher L · Gulf Shores, ALS/N D-9512 N2887RNaylor Michael Scott · Modesto, CABuilt 1967 · S/N 18258487 N2888ESterett Terry Alan Jr · New Port Richey, FLBuilt 1982 · S/N 18268218 N2888FLynch Neil E · Ceresco, MIBuilt 1966 · S/N 18256988 N2888KBooth William R Jr · Sterling, AKBuilt 1979 · S/N 18053119 N2889EWesellhigh LLC · West End, NCBuilt 1982 · S/N 18268219 N2889FLander Kirt E · Kingman, AZBuilt 1966 · S/N 18256989 N2889RAircraft Structural Repair Inc · Hamilton, MTBuilt 1967 · S/N 18258489 N2889YJust Jump Skydiving LLC · Laurens, NYBuilt 1962 · S/N 18253889 N288DMDavidson Christian · Auburn, WABuilt 2006 · S/N 29-0453 N288FGroove LLC · Afton, VABuilt 1965 · S/N D-7970 N288LSVacendak William A · Wasilla, AKS/N 32953 N288LTGlatczak Jerome · Schofield, WIBuilt 1963 · S/N 18255038 N288MTgc Aviation LLC · Watkinsville, GABuilt 2002 · S/N E-3460 N288MJRocky Ford Leasing LLC · Tallahassee, FLBuilt 2020 · S/N 4906 N288PBlue Water Aviation Inc · Jupiter, FLBuilt 1980 · S/N TH-1113 N288PKJdc Aero LLC · Champaign, ILBuilt 2011 · S/N 2089 N288PWSummit Peak Ventures LLC · Danville, CABuilt 2020 · S/N 2171 N288SVMartin Terry L II · De Soto, MOBuilt 1995 · S/N 95-301022 N288TATurbine Time LLC · Mercer Island, WABuilt 1999 · S/N TH-1926 N288TBCejka Robert K · Cudahy, CABuilt 1975 · S/N TC-1880 N288TMSlaba Mark E · Arcadia, FLBuilt 1967 · S/N 18258263

Back to AD 2000-23-21