Registered aircraft · 85,620

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

N20891Morristown Flying Service Inc · Talbott, TNBuilt 1974 · S/N 17263867 N20896Mccullar Miles Glenn · Hagerman, NMBuilt 1977 · S/N E-1163 N2089ESkyhawk N2089e Ltd · Deerfield, ILBuilt 1978 · S/N 17271151 N2089KBrown Frank J · Cold Spring, NYBuilt 1978 · S/N 44-7995176 N2089NSchroeder Reinhard · Poulsbo, WABuilt 1979 · S/N 28-7916255 N2089STxt Aviation LLC · Deland, FLS/N R18201299 N2089TBeusekom Jeremy Van · Eden Prairie, MNBuilt 1970 · S/N 28R-7135033 N2089WBaron 2089w LLC · Jupiter, FLBuilt 1966 · S/N TE-60 N2089XMoravitz Kim J · Turtle Lake, WIBuilt 1965 · S/N 18256189 N2089YSooter Craig A · Sedgwick, KSBuilt 1962 · S/N 17249589 N208ATLeciejewski Darrell K · Mc Alpin, FLBuilt 1976 · S/N 17268379 N208CAChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 4496161 N208EFAero208 LLC · Boise, IDBuilt 1966 · S/N 28-3632 N208GGPenn Yan Flying Club Inc · Penn Yan, NYBuilt 1975 · S/N 28-7690073 N208LHOtt Grosvenor LLC · Dillingham, AKBuilt 1974 · S/N U20602642 N208PGrateful Center Transportation LLC · Lutz, FLBuilt 1991 · S/N TH-1626 N208QPetersen Robert Trustee · Harrodsburg, KYBuilt 1965 · S/N TC-898 N208RGInland Northwest Aero LLC · Veradale, WABuilt 1966 · S/N 30-1152 N208SEJohn Stuart LLC · Miramar, FLS/N 27-4542 N208SSSeldom Seen Aviation Northwest Inc · Stevensville, MTBuilt 1974 · S/N 18502452 N208TMustang Sally LLC · Bullhead City, AZFirst renewal noticeBuilt 1974 · S/N E-572 N208TCKissee Zachary Robert · Chugiak, AKBuilt 1976 · S/N 18052749 N208THN208th LLC · Villa Rica, GAS/N 3246122 N208WPCassidy Ryan H · Seattle, WABuilt 1980 · S/N U20605836 N2090American Valet Air Inc · Wilmington, DEBuilt 1981 · S/N 27-8154010 N20907Ward Roger L · Ghent, WVBuilt 1972 · S/N 18261345 N2090GLight Chop LLC · Lexington Park, MDBuilt 1958 · S/N 51390 N2090LBarnes Seth M · Hot Springs, ARS/N D-10074 N2090RRubright Erik M · Gladstone, MIBuilt 1969 · S/N 28-4975 N2090VWater Sports Unlimited · Griffin, GABuilt 1979 · S/N 28-7990339 N2090XTreeline Services LLC · Grimes, IAS/N 18256190 N20914Jackson George F Jr · Saint Leonard, MDBuilt 1972 · S/N 18261294 N2091BRegistered aircraftBuilt 1978 · S/N 28-7990117 N2091DRegistration Pending · Magnolia, TXRegistration pendingBuilt 1978 · S/N 28-7916141 N2091LLippert John C · Danville, VABuilt 1976 · S/N E-967 N2091MGreat Planes Aviation Inc · Rochester, MNS/N 28-7816249 N2091PStahler Corporation Ltd · Bexley, OHBuilt 1979 · S/N 32-7940041 N2091VAircraft Partners LLC · Owensboro, KYBuilt 1979 · S/N 28R-7931108 N2091WDestefano Patrick · Adamsville, TNS/N 28R-7918076 N2091XBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 18256191 N2091YCut And Snip Flyers LLC · South Weber, UTBuilt 1962 · S/N 17249591 N20920Berry Danny · Rusk, TXBuilt 1972 · S/N 18261295 N20921Brigham David F · Elliottsville Twp, MEBuilt 1974 · S/N 17263869 N20923Langford Thomas R Jr · Mount Clare, WVBuilt 1972 · S/N 18261298 N20928Shelley Aaron J · Corbin, KYBuilt 1978 · S/N 32R-7887182 N20929Heinl Christopher · Hickory, NCBuilt 1972 · S/N 18261301 N2092AKimmons Anthony J · Quitman, TXBuilt 1978 · S/N 28-7916094 N2092CElam Nathan A · Hereford, TXBuilt 1978 · S/N 28-7911020 N2092DSelchow Stuart · Plato, MNBuilt 1978 · S/N 28-7911032 N2092GUllrich Sandy J · Haskell, OKBuilt 1958 · S/N 51392

Back to AD 98-21-21 R1