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.

N27GPFlying Colors Airparts Inc · Leesburg, FLBuilt 1977 · S/N U20604105 N27GRGolf Romeo Aviation LLC · Raleigh, NCBuilt 2021 · S/N 2367 N27HALmn Aircraft Leasing LLC · Sellersburg, INBuilt 1982 · S/N T30300064 N27HBBalk Christopher T · Arlington, WABuilt 1977 · S/N E-999 N27HMMaccarone Mario R · Wasilla, AKBuilt 1973 · S/N 1112C N27JAPacific Aviation Management Inc · Fresno, CABuilt 1976 · S/N 33701747 N27JCTalotta Nicholas J · Ocean City, NJBuilt 1960 · S/N CD-267 N27JPWillis Roger · Bellview, FLS/N 39129 N27KVWood Eugene H · Hickory, NCBuilt 2015 · S/N T24002094 N27LEQuality Feed Grains · Harrison, ARBuilt 2000 · S/N 00-301030 N27LGStilda One LLC · Fort Loramie, OHBuilt 2008 · S/N 3052 N27LHStavros Andrew · San Jose, CABuilt 1972 · S/N E-375 N27LPPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N 25-0408 N27MLHam Aviation LLC · Marydel, DEBuilt 2016 · S/N 1269 N27MTFlying Dog Aviation LLC · Swanton, OHBuilt 1980 · S/N TH1120 N27MXStewart Aviation LLC · Atlanta, GABuilt 2023 · S/N 9168 N27MYBloomaker Holding Aero Service Inc · Waynesboro, VABuilt 2018 · S/N 1787 N27PBMountain Lake Aviation LLC · Newark, DEBuilt 2024 · S/N 10018 N27PFNorthstar Global Flight LLC · Bronxville, NYBuilt 2024 · S/N 9982 N27PKOgary Aviation LLC · North Little Rock, ARBuilt 1993 · S/N TH-1687 N27PY27py LLC · San Juan, PRBuilt 2026 · S/N 11456 N27RGReya Sunshine LLC · Coral Gables, FLBuilt 2023 · S/N 9245 N27SC5c Aviation LLC · Scottsdale, AZBuilt 1978 · S/N P21000181 N27THood David · Odessa, TXBuilt 1980 · S/N E-1783 N27THArizona Cloudbusters Inc · Mesa, AZBuilt 1966 · S/N CD-1015 N27TSSalerni Anthony A · Bedford, NHBuilt 2016 · S/N LIV-244 N27VMBlue Star Aviation LLC · Saint Augustine, FLBuilt 1969 · S/N TE-698 N27VPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1985 · S/N 18268451 N27WMHeidebrink Ronald E · West Chester, OHS/N 28R7703197 N27WVN27wv LLC · Shortsville, NYBuilt 2004 · S/N 1031 N27XDSweetgrass Flyers LLC · James Island, SCBuilt 2010 · S/N 72436 N28009Merritt Lisa Lawrence · Liberty, TXBuilt 1978 · S/N 78-30878 N2800FMeyer Scott R · Palm Harbor, FLBuilt 1966 · S/N 18256900 N2800YCherokee 92t LLC · Polk, OHBuilt 1962 · S/N 18253800 N28010Myers Charles G · Portland, ORBuilt 1978 · S/N 79-30908 N28012Carlton William A · Flower Mound, TXBuilt 1978 · S/N 78-30873 N28013Selzer Scott · Anchorage, AKBuilt 1979 · S/N 79-30955 N2801KGerrity James L · Homer, AKBuilt 1979 · S/N 18053072 N2801LAv8sgf LLC · Rogersville, MOBuilt 2017 · S/N 4475 N28021Prieto David · Fair Lawn, NJBuilt 1979 · S/N 79-30958 N28022Selck Frederic W · Washington, DCBuilt 1978 · S/N 78-30881 N28025Registered aircraftBuilt 1979 · S/N 79-30953 N28026Atwood Grace · Minneapolis, MNBuilt 1980 · S/N 80-30979 N28028Mitzoom Enterprises LLC · Minneapolis, MNBuilt 1979 · S/N 79-30948 N2802AHamilton Elson · Fort Bragg, CABuilt 1953 · S/N 30002 N2802FC-All Mfg Inc · Atoka, OKBuilt 1966 · S/N 18256902 N2802JCentral States Aerial LLC · Polo, ILBuilt 1979 · S/N T18803515T N2802KBloom Timothy Scott · Chugiak, AKBuilt 1979 · S/N 18053073 N2802QPrecision Management LLC · Bossier City, LABuilt 1962 · S/N 18254034 N280314s Holdings LLC · Wilmington, DEBuilt 1979 · S/N 79-30926

Back to AD 2000-23-21