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.

N2210QSymphony Air LLC · Medford, NYBuilt 1977 · S/N 32R-7780234 N2210RCarroll James K · Paso Robles, CAS/N T210-0360 N2210WGarg Ken M · Brewster, NYBuilt 1998 · S/N 24-3423 N2210XDraco Flight School DBA · Chino, CABuilt 1979 · S/N 28-7916351 N22117Von Ahlefeldt Alan R · Parker, COBuilt 1978 · S/N 32R-7887244 N2211CChampigny Jean-Pierre · Harrison, NYBuilt 1982 · S/N 28-8290097 N2211DKuhn Michael D · Knapp, WIBuilt 1952 · S/N 20363 N2211EDe La Osa Jorge · Treasure Island, FLBuilt 1978 · S/N 28-7911045 N2211FSkyvault Holdings LLC · Saint Petersburg, FLBuilt 1960 · S/N 39235 N2211GKoepplin Ricky G · Missoula, MTBuilt 1958 · S/N 51511 N2211JEpstein Adam S · Milford, MABuilt 1978 · S/N 28-7911066 N2211UHooten Joshua C · Heber Springs, ARS/N 32R-7985090 N2211WTucker Christian Taylor · Butler, MOBuilt 1964 · S/N 2875 N2211ZN2211z LLC · Lake Worth, FLBuilt 1979 · S/N 28-7916389 N22121Registration Pending · Georgetown, TXRegistration pendingBuilt 1972 · S/N 21059711 N2212ASiewart Michael · Columbus, OHS/N 310G-0018 N2212DMichel David L · Greenville, SCBuilt 1973 · S/N 28R-7335443 N2212PHollingshead Terry L · Flint, MIS/N 23-821 N2212RFlystar Aviation LLC · Tampa, FLBuilt 1969 · S/N 28-5485 N2212WCleveland Frank W · Quinhagak, AKBuilt 1978 · S/N 17271516 N22131Kraxberger Rick R · Kasilof, AKBuilt 1976 · S/N 18503074 N22136Zest Fest Corporation Of Oregon · San Diego, CAS/N 32R-7887247 N2213CTruffer Martin · Fairbanks, AKBuilt 1953 · S/N 30513 N2213FJ & M Airways LLC · Troy, MIBuilt 1978 · S/N 28-7911050 N2213GAnzion Susan K · Nerstrand, MNBuilt 1958 · S/N 51513 N2213MWeels Up Inc · Pasadena, CABuilt 1979 · S/N 28-7911092 N2214CMarks Richard J IV · Norway, MEBuilt 1953 · S/N 30514 N2214DLillian Aviation LLC · Cypress, TXBuilt 1978 · S/N 28-7911036 N2214FSky Financial Services Inc · Center Valley, PABuilt 1978 · S/N 32R-7985042 N2214GGanfield Roger A · Guernsey, WYBuilt 1958 · S/N 51514 N2214MWings Flying Club Inc · South Bend, INBuilt 1977 · S/N 28-7890234 N2214PMaslen Holbrook · Caldwell, IDS/N 23-823 N2214VJohr Bernardo M · Pembroke Pines, FLBuilt 1979 · S/N 28R-7931115 N2215QMoore Verba A · Biloxi, MSBuilt 1979 · S/N 28R-7918054 N2215TBackcountry Wagons LLC · Kalispell, MTBuilt 1968 · S/N 185-1367 N2215ZAjb Holdings LLC · Rock Hill, SCBuilt 1979 · S/N 28-7990406 N2216CAero Mark Inc · Idaho Falls, IDBuilt 1953 · S/N 30516 N2216FSummit North LLC · Anchorage, AKBuilt 1982 · S/N U20606504 N2216QQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N 28R-7931069 N2216URegistered aircraftBuilt 1974 · S/N U20602355 N2216YPacific Union College · Angwin, CABuilt 1979 · S/N 44-7995290 N22175Johnson Richard E · Duluth, MNBuilt 1978 · S/N 28-7916062 N2217CSale Reported · Kerrville, TXSale reportedBuilt 1979 · S/N 18267230 N2217DDaytona Jets LLC · Daytona Beach, FLBuilt 1978 · S/N 44-7995137 N2217EBaughman Thomas · Napoleon, OHBuilt 1978 · S/N 32R-7985039 N2217KRoss Mitchell B · Ledyard, CTBuilt 1978 · S/N 28-7916226 N2217RParke Mike D · Twin Falls, IDBuilt 1968 · S/N T210-0367 N2217TTango LLC · Anchorage, AKBuilt 1968 · S/N 185-1369 N2217YLehmer Kenneth D Trustee · Pls Vrds Est, CABuilt 1959 · S/N D-6056 N2218CMart Gary A · Bend, ORS/N 30518

Back to AD 98-21-21 R1