Registered aircraft · 85,612

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.

N2821QHattan Richard A Trustee · Fairbanks, AKBuilt 1977 · S/N 18503533 N2821RNielson David L Trustee · Anchorage, AKBuilt 1967 · S/N 18258421 N2821UPelotte Raymond J · Waterville, MEBuilt 1963 · S/N 17250421 N2821VSchmitt Rudy · Brookshire, TXBuilt 1947 · S/N D-225 N2822CNeverman Walter M · Albany, WIBuilt 1954 · S/N 26365 N2822GWorsham Investments LLC · Tulsa, OKBuilt 1979 · S/N 28-7911137 N2822LRobertson IV Henry B · Owensboro, KYS/N 17256022 N2822MWendt Robert R · Sedona, AZBuilt 1953 · S/N 30010 N2822STwo Two Sierra LLC · Austin, TXBuilt 1979 · S/N 28-7990470 N2822YThayer Robert N · Portola, CABuilt 1979 · S/N 28-7990471 N28235Registered aircraftBuilt 1969 · S/N 28-11253 N2823AMckinney Eric S · Hamersville, OHS/N 30023 N2823CJones Adam · Fairbanks, AKBuilt 1954 · S/N 26366 N2823DOloteo Dennis R Jr · San Antonio, TXBuilt 1979 · S/N 28-7990472 N2823E2lyons Enterprises LLC · Westlake, FLBuilt 1978 · S/N 17271335 N2823TAircraft Restoration LLC · Valparaiso, INBuilt 1972 · S/N 28R-7235140 N2823UPowell Mark J · Chelsea, MIBuilt 1963 · S/N 17250423 N2823WSmith Scot · Fayetteville, NCBuilt 1981 · S/N 24-1101 N2824AStrode Lawrence W · Naknek, AKS/N 30024 N2824CReilly Richard J · St Paul, MNBuilt 1954 · S/N 26367 N2824DSchaible John A · Moneta, VAFirst renewal noticeBuilt 1979 · S/N 28R-7918159 N2824QAv8 LLC · Davenport, IAS/N 17259824 N2824TEscudier Henry · Houston, TXBuilt 1972 · S/N 34-7250171 N2824VBigfoot Aviation LLC · Saint Michael, MNBuilt 1947 · S/N D-228 N2824YForbes Aviation LLC · Boise, IDBuilt 1979 · S/N 28R-7918161 N28251Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843729 N2825CSouza Clifford A · Pattersonville, NYBuilt 1954 · S/N 26368 N2825FStephens Jeffrey G · Gig Harbor, WABuilt 1966 · S/N 18256925 N2825KHigh Flying Club Inc · Fort Wayne, INBuilt 1979 · S/N 28R-7931212 N2825MStanton Jeffrey C · Bracey, VABuilt 1977 · S/N 28-7816313 N2825ROjeda Holdings LLC · Gainesville, GABuilt 1967 · S/N 18258425 N2825TBeatty Daniel H · Bronx, NYS/N 28R-7235122 N2825XJames Ray Inc · Twin Falls, IDS/N P206-0025 N2825YSalva Kenneth J · Shingle Springs, CABuilt 1962 · S/N 18253825 N2826AConfer Gary R · Washougal, WABuilt 1953 · S/N 30026 N2826CSolstice Joshua A · Anchorage, AKS/N 26369 N2826HN2826h LLC · Elizabethville, PABuilt 1979 · S/N 32-7940144 N2826LJamtori Investments LLC · Forrest City, ARS/N 17256026 N2826QMcmillan Roger L · Camdenton, MOBuilt 1971 · S/N 17259826 N2826TKochersberger Kevin B · Blacksburg, VABuilt 1972 · S/N 28R-7235016 N2826UJohnson James E · College Station, TXBuilt 1963 · S/N 17250426 N2826XAero Talons LLC · Nashville, TNS/N 32-7940145 N2826YMorgan Lewis Brian · Allen, TXS/N 32-7940146 N2827CCalifornia Equipment Leasing LLC · Marina Del Rey, CABuilt 1978 · S/N R18200233 N2827NN714dd LLC · Pembroke Pines, FLBuilt 1979 · S/N 34-7970262 N2827TRegan Keith M · Torrance, CABuilt 1965 · S/N CD-953 N2828ALatham Cory D · Great Bend, KSS/N 30028 N2828FSmiley Neil J Trustee · Lake Havasu City, AZBuilt 1966 · S/N 18256928 N2828KStephens Mark Edwin Trustee · Morgan Hill, CABuilt 1979 · S/N 18053091 N2828LInverted LLC · Las Vegas, NVS/N 34-7970266

Back to AD 98-21-21 R1