OpenAirDocs.org
AD 98-21-21 R1

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
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.

N2873RMitchell Daniel E · Lubbock, TXBuilt 1969 · S/N 28R-35312N2873TMmrrc LLC · Lighthouse Point, FLS/N 28-7911216N2873UBaker Douglas R · Ann Arbor, MIS/N 32-7940171N2873WHolland Edgar S · Fletcher, NCBuilt 1973 · S/N TC-1580N2873XJag III Aviation LLC · Clarksdale, MSS/N 32-7940172N2873YMorris Ben M · Albany, GABuilt 1962 · S/N 18253873N2874CLarson Ivan · Parker, AZBuilt 1954 · S/N 26417N2874EMoutafian Adom · Los Gatos, CAS/N 21062773N2874KWashburn Kent F · Grants Pass, ORBuilt 1979 · S/N 18053110N2874LSchirack John · Decatur, INBuilt 1967 · S/N 17256074N2874XMorin Joseph A · Fiskdale, MAS/N 28-7916496N2874ZAdvanced Aviation Concepts LLC · Gainesville, FLBuilt 1979 · S/N 28-7916497N2875BRas Aviation LLC · Elyria, OHBuilt 1979 · S/N 28-7916499N2875GBerger Joseph A · Mount Sterling, OHBuilt 1979 · S/N 28-7916501N2875LDavenport Ross K · Raleigh, NCBuilt 1967 · S/N 17256075N2875QLani Lea Sky Tours LLC · Honolulu, HIBuilt 1971 · S/N 17259875N2875RLyons Corey · Vinton, OHS/N 28R-35315N2875UWalter Karl F · Fayetteville, GABuilt 1963 · S/N 17250475N2875WTreadway Ag Delaware LLC · Lewes, DES/N D-9508N2875XParis Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-7916502N2875ZPacific Gold Aviation Association Inc · Roseville, CAS/N 28-7990513N28761Hall James K · Tiffin, OHBuilt 1979 · S/N 28-7916415N2876CBreaux Joseph M · Gonzales, LABuilt 1979 · S/N 28-7990514N2876FJohnston Natalie R · Edgewood, TXBuilt 1966 · S/N 18256976N2876RTorley Air Service LLC · Colorado Springs, COBuilt 1969 · S/N 28R-35316N2876TGear Up Aircraft Rental LLC · Warner Robins, GABuilt 1972 · S/N 28-7225261N2876UPianalto David · Wichita, KSBuilt 1963 · S/N 17250476N2876YForbes Richard L · Plano, TXBuilt 1962 · S/N 18253876N2877ADutremble Donald L · Amherst, NHBuilt 1953 · S/N 30077N2877BGreat Planes Aviation Inc · Rochester, MNBuilt 2000 · S/N 2843402N2877CCarlson John R · Plainfield, WIBuilt 1954 · S/N 26420N2877MMajors Flying Club · Greenville, TXBuilt 1979 · S/N 28-7990519N2877UMelin James · Livingston, MTBuilt 1963 · S/N 17250477N2877YBrumback Recreation LLC · Bluffdale, UTBuilt 1962 · S/N 18253877N2878AAero Garage Inc · Fort Myers, FLS/N 30078N2878CGullion Joshua A · Weldona, COBuilt 1954 · S/N 26421N2878LHolbrook David A · Toccoa, GABuilt 1967 · S/N 17256078N2878MCamous Alain E · Sunrise, FLBuilt 1977 · S/N 28R-7803152N2878NRace Ralph D · Brookland, ARS/N 28R-7918194N2878QFields Williams H · Greensboro, NCBuilt 1971 · S/N 17259878N2878ULundstroem Ulf · Fort Pierce, FLS/N 28R-7918195N2878YBright Sky Aviation Inc · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 28R-7931235N2879CAero Jackson LLC · Bradenton, FLBuilt 1979 · S/N 28R-7931237N2879FMinich Sophie R · Anchorage, AKS/N 18256979N2879KTwo Niner Kilo LLC · Seattle, WABuilt 1979 · S/N 18053115N2879PHarrison T Mark · Los Angeles, CAS/N 28R-7931238N2879QBlue Side Aviation LLC · Tampa, FLBuilt 1971 · S/N 17259879N2879WEvenson Paul S · Grant, MNBuilt 1979 · S/N 28R-7931239N2879YDawson Ronald Dwight Sr · Garland, TXBuilt 1987 · S/N 28R-7931240N287BGD&J Aviation LLC · Apopka, FLBuilt 2006 · S/N 2842260
Back to AD 98-21-21 R1