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.

N2147ZScott Jeffery A · Stephenville, TXBuilt 1979 · S/N 28-7921020 N21481Houston Christopher T · Webster, NYBuilt 1978 · S/N 28-7916044 N21485Dipzinski Victor L · Clio, MIFirst renewal noticeBuilt 1974 · S/N 17263956 N21487Millennial Flight LLC · Kalispell, MTS/N 18261663 N21488Mission Hardware LLC · Savannah, GABuilt 1973 · S/N 18261664 N21489D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7990050 N2148BKaroudjian David · Savannah, GAS/N 32R-7987030 N2148CLarsen Timothy · Marietta, GABuilt 1997 · S/N 24-3405 N2148FRegistration Pending · Wilmington, DERegistration pendingBuilt 1978 · S/N 44-7995157 N2148GMissildine Ronald E Trustee · Simi Valley, CABuilt 1958 · S/N 51448 N2148LL&M Cleared2land LLC · Coral Gables, FLBuilt 1976 · S/N E-897 N2148N2 Delta 5 LLC · Oakes, NDBuilt 1979 · S/N 32R-7985069 N2148PHorizon Aviation LLC · Buffalo, NYBuilt 1979 · S/N 32-7940043 N2148XMckinley John Perry · Amarillo, TXBuilt 1979 · S/N 28R-7931129 N2148ZMalburg Phillip E · Holland, MIBuilt 1979 · S/N 28-7916378 N21490Erff David F · Madison, CTBuilt 1973 · S/N 18261666 N21492Puryear Rodney K · Pampa, TXS/N P21000641 N21494Dmc Air LLC · West Chester, OHS/N 32R-7887216 N21495Taylor Jason R · Moab, UTBuilt 1973 · S/N 18261670 N21499Kling Clint W · Summerset, SDBuilt 1978 · S/N 32R-7887218 N2149DSeaton Brad S · Cache, OKBuilt 1978 · S/N 32R-7985031 N2149EPierce Martin H · Big Sky, MTBuilt 1978 · S/N 28-7911044 N2149GBay Darren J · Springville, CABuilt 1958 · S/N 51449 N2149JN2149j LLC · Colorado Springs, COBuilt 1978 · S/N 28-7911061 N2149LRocky Hill Airshows Inc · San Jose, CABuilt 1976 · S/N E-898 N2149TChandler Air Service Inc · Chandler, AZBuilt 1979 · S/N 28-7911114 N2149YTurner Darryl Ray · Copperopolis, CABuilt 1962 · S/N 17249649 N2149ZBauer Jeff C · North Falmouth, MABuilt 1980 · S/N 28-7916380 N214APikago LLC · Moreno Valley, CABuilt 1978 · S/N 17270830 N214AALewis University · Romeoville, ILS/N 28-4735 N214ANCalifornia In Nice Inc · San Jose, CAS/N 17267499 N214BPHolmes Aviation Inc · Webster, FLBuilt 2000 · S/N 3257156 N214CALester Don · Campton, NHBuilt 1974 · S/N 28R-7435281 N214CHFlycarolina LLC · Concord, NCBuilt 1980 · S/N TH-1160 N214DMGrueninger Mark J · Benton, ILBuilt 1962 · S/N TC-285 N214DRMarsh David · Flower Mound, TXBuilt 1969 · S/N D-8997 N214DTBudicin Dominic A · Cedarpines Park, CABuilt 1979 · S/N 18266910 N214EDWoods Johnny I · Hendersonville, TNBuilt 1980 · S/N 44-8195007 N214EPShumway Edwin · Tekonsha, MIBuilt 1956 · S/N 32485 N214ERLima-001 LLC · Muscatine, IAS/N 17263480 N214ESIsaacs Mark S · Terre Haute, INBuilt 1961 · S/N 18253673 N214GGilpin Sean F · Madison, ALBuilt 1976 · S/N 21061237 N214GKSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 34-8633001 N214GSStephens Mark · Cullman, ALBuilt 1972 · S/N 28-7205138 N214HSDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1975 · S/N 27-7654014 N214JC214 Mooney LLC · Boca Raton, FLBuilt 1978 · S/N 24-0706 N214JMVisions In Design LLC · Fairmont, WVBuilt 1977 · S/N 28R-7703059 N214JNFox-1 Drafting & Design Inc · Eagan, MNBuilt 1966 · S/N 30-1130 N214JPTop Flight Leasing LLC · Frankfort, ILBuilt 1994 · S/N 3213083 N214KPBnb Aviation LLC · Chesterfield, MOBuilt 1999 · S/N TH-1894

Back to AD 98-21-21 R1