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.

N248DDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1966 · S/N TE-171 N248ERUnverferth Gregory T · Fort Jennings, OHS/N 17271977 N248HSLitchfield Lantz · Las Vegas, NVBuilt 1978 · S/N 21062726 N248JBRiverode Sales Inc · Pontiac, ILBuilt 1978 · S/N TC-2124 N248KCracker Aviation LLC · Jupiter, FLBuilt 1975 · S/N 27-7654004 N248LTOconnell Christopher · Tucson, AZBuilt 1975 · S/N 34-7570019 N248MHatton Wesley · Murrieta, CABuilt 1964 · S/N TC-558 N248MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881711 N248PVVasquez Pablo Javier Jr · El Dorado Hills, CABuilt 1991 · S/N 243221 N248TFVisionary Holdings LLC · Missoula, MTBuilt 2025 · S/N 4496613 N248ZLightsey Aviation LLC · Jacksonville, FLBuilt 1967 · S/N 17256247 N2490LWimberly Thomas F III · Bend, ORBuilt 1966 · S/N 17255690 N2490MDmld Corp · Wilmington, DEBuilt 1977 · S/N 28-7890254 N2490RBirdie Air LLC · Wichita, KSBuilt 1964 · S/N 18255590 N2490UBredbenner Carl A · Dalmatia, PABuilt 1963 · S/N 17250090 N2490XFoley David A Trustee · Afton, WYBuilt 1965 · S/N 18256390 N2490YSheboygan Flight Plane III LLC · Sheboygan, WIBuilt 1985 · S/N 28-8590077 N2491GShowah Christopher Douglas · Indianola, MSS/N 51791 N2491LMcgivern James · San Pedro, CABuilt 1966 · S/N 17255691 N2491QLong Daniel · Stevenson, ALBuilt 1966 · S/N 18257691 N2491RDaly John M · Fort Worth, TXBuilt 1964 · S/N 18255591 N2491TLichtman Bruce A · Stafford, VABuilt 1971 · S/N 28-7225078 N2491XBaalman Murray J · Grinnell, KSBuilt 1965 · S/N 18256391 N2492CTjossem Martin O · Paullina, IABuilt 1954 · S/N 30792 N2492SSierra Hotel Aircraft LLC · Wilmington, DEBuilt 1976 · S/N 21061302 N2492TOmni Aviation LLC · Pickerington, OHBuilt 1971 · S/N 28-7205060 N2492YBenham Charles D · San Angelo, TXBuilt 1968 · S/N E-74 N2493CBallard Bradley J · Youngsville, NCBuilt 1954 · S/N 30793 N2493QTarrant Enterprises Inc · Eagle, COBuilt 1966 · S/N 18257693 N2493XKoenig William T · Sauk Centre, MNBuilt 1965 · S/N 18256393 N2493YBeauchamp Chris L · Anacortes, WABuilt 1962 · S/N 17249793 N2494DPristo Paul J · Scottsdale, AZBuilt 1948 · S/N 20646 N2494MJbbs Enterprises Inc · Middletown, DEBuilt 1977 · S/N 28-7890255 N2494QMcculloch Kyle · Bixby, OKBuilt 1966 · S/N 18257694 N2495Lynch Sean L · Brighton, ILBuilt 1978 · S/N 17270282 N2495FKalbfleisch George R · Dry Ridge, KYBuilt 1966 · S/N 18051697 N2495GHayton James B · Sedro Woolley, WABuilt 1959 · S/N 51795 N2495MPark Brian D · Springville, UTBuilt 1977 · S/N 28R-7837090 N2495RSale Reported · Saint Augustine, FLSale reported, canceledBuilt 1964 · S/N 18255595 N2495TAvia Flight Academy LLC · Stratford, CTBuilt 1971 · S/N 28-7205061 N2495UKoelbl Aviation LLC · Whitesboro, TXBuilt 1963 · S/N 17250095 N2496FKrissman Ryan · Gallup, NMS/N 18051695 N2496LSequeira Michael J · Troy, MOBuilt 1966 · S/N 17255696 N2496MMorgan Jay · Fort Mill, SCBuilt 1977 · S/N 28R-7837091 N2496UKloker Daniel E · Owasso, OKBuilt 1963 · S/N 17250096 N2496YSchwab George E · Stillwater, OKBuilt 1962 · S/N 17249796 N2497EBenham Aviation LLC · Enid, OKBuilt 1978 · S/N 17271303 N2497GChapman William F · Coeur D Alene, IDBuilt 1959 · S/N 51797 N2497RMarkley John T · Center Harbor, NHBuilt 1969 · S/N 28-5636 N2497XVoeltzel Rick K · Rio Rico, AZBuilt 1965 · S/N 18256397

Back to AD 98-21-21 R1