Registered aircraft · 85,616

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.

N106JLMusic City Air LLC · Rogersville, ALBuilt 1963 · S/N 27-2416 N106KV3 Aviation LLC · Lexington, OKBuilt 1975 · S/N E-716 N106LValiair Lc Trustee · Casper, WYBuilt 2000 · S/N 3257130 N106MBBaron Phoenix Aviation LLC · Newport, RIBuilt 2000 · S/N TH-1935 N106MRIsland Flights Inc · Wilmington, DEBuilt 1981 · S/N 32-8206009 N106MSKundel Richard · Cedar Rapids, IABuilt 1974 · S/N 28-7525063 N106NChenevert Eric M · Clarence, NYBuilt 1962 · S/N D7035 N106NAVann-Tage Point Aviation LLC · New Castle, DES/N 32-704 N106PESheboygan Flying Club LLC · Sheboygan, WIBuilt 1977 · S/N 28R-7837088 N106PSScarrow James D · Jerome, IDBuilt 1976 · S/N 18264800 N106QIntegrity Aero LLC · Boerne, TXS/N 25-1208 N106REColorado Aircraft Corp · Watkins, COS/N 31-7752056 N106RGCadena Edward R Jr · Houston, TXBuilt 1966 · S/N 18257535 N106RMArmstrong Ronald W · Brownsville, TXBuilt 1983 · S/N R18201932 N106UMiha LLC · Dover, DEBuilt 1956 · S/N 32325 N106VKenyon Joseph S · Fort Collins, COBuilt 1959 · S/N D-6009 N1070BCurtis Julia A · Holladay, UTBuilt 1964 · S/N 24-3620 N1070WHill Richard P · Jacksonville Beach, FLBuilt 1973 · S/N CE-431 N1070XMosby Group LLC · Edgerton, MOBuilt 1975 · S/N 34-7570199 N1070ZSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1990 · S/N 25-1222 N10712Hall Air Inc · Weiner, ARBuilt 1961 · S/N TC-59 N10719Florida Independent Truck Repair Inc · Greeneville, TNBuilt 1990 · S/N 24-3141 N1071AOcean Group LLC · Plantation, FLBuilt 1979 · S/N 31-7952195 N1071CBmk Aviation LLC · Northampton, PABuilt 2006 · S/N 2843648 N1071MJesperson Kenneth R · Ekalaka, MTBuilt 1969 · S/N T210-0451 N1071PFlying Circus Aircraft LLC · Manitou Beach, MIBuilt 1954 · S/N 23-82 N1071TChambliss Aviation Services LLC · Greer, SCBuilt 1976 · S/N TC-2002 N1071UCrowder Zachary · Merritt Island, FLBuilt 1989 · S/N 24-3140 N1071WPcs Air LLC · Middletown, PABuilt 1973 · S/N E-417 N1071XPeter Prince Aviation Center LLC · Milton, FLBuilt 1975 · S/N 28-7525274 N1071YBreaux John Jr · Minden, NVS/N 24-1124 N10725N22154 Inc · Wilmington, DES/N 24-3143 N1072FGeorgia Air LLC · St Simons Island, GABuilt 1996 · S/N E-3002 N1072NStephens Donald G · Huntington Beach, CAFirst renewal noticeBuilt 1981 · S/N 24-1125 N1072QCoastal Air Inc · Groton, CTBuilt 1977 · S/N 28-7725180 N1072XDemaagd Ross E · Middleville, MIBuilt 1975 · S/N 28-7505206 N1072YRyan Aaron · Wichita Falls, TXBuilt 1995 · S/N 24-3369 N1072ZCorbett Henry E · Salem, ORBuilt 1981 · S/N 24-1126 N1073BPickering Michael A · Walpole, NHS/N 1300 N1073FFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1979 · S/N 17272946 N1073MScr Aviation LLC · Austin, TXBuilt 1975 · S/N 18264219 N1073QRegistration Pending · Polo, MORegistration pendingBuilt 1963 · S/N 310H0073 N1073SAlabama Department Of Transportation · Montgomery, ALBuilt 1996 · S/N TH-1773 N1073UHasan Shah Pc · Fishers, INBuilt 1990 · S/N 24-3146 N1073XAustin Arrows Inc · Austin, TXBuilt 1975 · S/N 28R-7535232 N1074FNorth River Air LLC · Fairbanks, AKBuilt 1975 · S/N 18502730 N1074MBranca Richard A · Sebastian, FLBuilt 1990 · S/N 24-3147 N1074SReyes Mario A · Corpus Christi, TXBuilt 1981 · S/N 24-1127 N1074TIowa Lakes Community College · Estherville, IABuilt 1973 · S/N 17262233 N1074WDreamweaver Aviation LLC · Citra, FLS/N CE-432

Back to AD 98-21-21 R1