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.

N20972Esmiol Matthew · Marlborough, CTBuilt 1972 · S/N 18261331 N20975American Union Printing Inc · Chino Valley, AZBuilt 1972 · S/N 18261333 N20976Kwolik Jordan M · Mckinney, TXBuilt 1972 · S/N 18261334 N20978Crosswinds Flying Club Inc · Oakland, MIBuilt 1972 · S/N 18261336 N2097DDandekar Shree Ajit · Cedar Park, TXBuilt 1953 · S/N D-3442 N2097MDm Asset Management LLC · Plain City, OHS/N 28-7890229 N2097NSidney Flying Club Inc · Sidney, OHBuilt 1979 · S/N 28-7916257 N2097RWilson Wayne D · Saratoga Springs, NYBuilt 1964 · S/N 18255297 N2097UNorris Barry D · Soquel, CABuilt 1979 · S/N 28-7916311 N2097XSouth Carolina Forestry Commission · Columbia, SCBuilt 1965 · S/N 18256197 N2097YWulff Jonathan P · Eaton Rapids, MIBuilt 1962 · S/N 17249597 N20980White Duane A · Wappingers Falls, NYBuilt 1972 · S/N 18261337 N20985Aero X Flying Club Inc · Winchester, VAS/N 28-7990029 N20986Skylane Flying Club Inc · Omaha, NEBuilt 1972 · S/N 18261342 N2098PRegistration Pending · Granger, IARegistration pendingS/N 23-686 N2098TIsaacs Brandon · Homedale, IDBuilt 1971 · S/N 28R-7135043 N2098WHolland Greg R · Irvine, CABuilt 1966 · S/N CE-9 N2098XKuefler Michael J · Saint Ignatius, MTBuilt 1965 · S/N 18256198 N2098YLevel Altitude LLC · Seward, NEBuilt 1962 · S/N 17249598 N2099Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020179 N20992Sketo Aviation LLC · Bardstown, KYBuilt 1978 · S/N 28-7990030 N20997Aerowood Aviation LLC · Monroe, NCBuilt 1964 · S/N 17251217 N2099CFrazier Jon A · Vista, CAS/N TD-276 N2099GHilten Robert W · Columbus, MTBuilt 1958 · S/N 51399 N2099TArrowmark LLC · Schroeder, MNBuilt 1971 · S/N 28R-7135044 N2099XGreen Glen A · Willits, CABuilt 1965 · S/N 18256199 N209DPBke Air LLC · Newnan, GABuilt 1977 · S/N 17270158 N209HVAnderson Scott · Salem, ORBuilt 1979 · S/N 17272302 N209JRegistered aircraftBuilt 1982 · S/N 28-8216153 N209KSSchneider Kerry · Alpine, WYS/N P21000560 N209PTSilver Express DBA · Miami, FLBuilt 1979 · S/N 44-7995239 N209SCInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 28-7625115 N20ALilbit Industries LLC · Oklahoma City, OKBuilt 1955 · S/N 23-396 N20AAGrand River Aviation LLC · Kremmling, COBuilt 1968 · S/N 17256596 N20ACOwen Ray L · Los Gatos, CABuilt 1972 · S/N D9371 N20AZDelta Juliet Wings LLC · Kennesaw, GABuilt 1979 · S/N 28-7911153 N20BBlackard William R Jr · Jacksonville, FLBuilt 1976 · S/N 32R-7680387 N20BRYork Stanley A · Leetonia, OHBuilt 1955 · S/N 31563 N20BUN20bu LLC · Champaign, ILBuilt 1977 · S/N 27-7754063 N20BWN220kw LLC · Moses Lake, WABuilt 1976 · S/N 32R-7680355 N20CFFried Stephen · Plymouth, MAS/N 26217 N20CHRegistered aircraftBuilt 1974 · S/N 18263453 N20CSChandan Dreamworks Inc · Wilmington, DES/N E-3601 N20DEEbright Sean E · Hasty, COS/N 51334 N20DJBeach Bum Airways LLC · Saint Petersburg, FLBuilt 1966 · S/N TE-191 N20DKFlight Surgeon LLC · Fayetteville, ARBuilt 1976 · S/N 17266836 N20DMLowe Aviation Co · Macon, GABuilt 1973 · S/N 27-7305066 N20EHUnzicker Keith R · Benson, ILBuilt 1966 · S/N 1090 N20EZRegistration Pending · Bigfork, MTRegistration pendingBuilt 1969 · S/N 310P0078 N20FCLge Flying Club Inc · Marietta, GABuilt 1970 · S/N 18260314

Back to AD 98-21-21 R1