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.

N2833SJohanson Lawrence Gco Trustee · Mckinleyville, CAS/N 28-7916458 N2833YLancaster Mark E · Buffalo, SCBuilt 1962 · S/N 18253833 N2834ADalton John B · Dallas, ORBuilt 1953 · S/N 30034 N2834BSager Arthur · Joseph, ORBuilt 1979 · S/N 28-7990477 N2834COsborne David A · San Antonio, TXBuilt 1978 · S/N R18200235 N2834LRomano Kenneth J · Shirley, NYBuilt 1967 · S/N 17256034 N2834QHarford Flying Club Inc · Kingsville, MDBuilt 1971 · S/N 17259834 N2834RPence Levi B · Quincy, CABuilt 1967 · S/N 18258434 N2834TCrosswire Networks & Camera Systems Inc · Tampa, FLS/N 28-7990478 N2834VKieper Mark A · Hampton, MNBuilt 1947 · S/N D-239 N2835AAllen Airplane LLC · Durango, COBuilt 1953 · S/N 30035 N2835CTroutman Charles W · Prineville, ORFirst renewal noticeBuilt 1954 · S/N 26378 N2835FAdams Stephen L A · Fortuna, CAS/N 18256935 N2835KGardner Thomas W · Lincoln, MEBuilt 1979 · S/N 18053093 N2835LBrinkmac LLC · Cadillac, MIS/N 17256035 N2835MWth Aviation Services LLC · Scott City, KSBuilt 1977 · S/N 28-7890271 N2835NDelsair Inc · Maitland, FLBuilt 1979 · S/N 28R-7931216 N2835QSan Fernando Aviation LLC · Van Nuys, CABuilt 1971 · S/N 17259835 N2835TFitzpatrick Robert M · Fredericksburg, TXBuilt 1979 · S/N 28-7911196 N2835YRafter S Contractor Services LLC · Cuero, TXBuilt 1962 · S/N 18253835 N28360Albert Lea Airport Inc · Albert Lea, MNBuilt 1979 · S/N 28-7916403 N28361Propell Air LLC · Deridder, LAS/N 28-7916404 N2836ABond Darren R · San Antonio, TXBuilt 1953 · S/N 30036 N2836FPaul Jr Johnny D · Camden, SCBuilt 1966 · S/N 18256936 N2836GRed Rock Fly LLC · Lewes, DEBuilt 1979 · S/N 28-7916459 N2836LRyan Patrick J · Quinton, VABuilt 1967 · S/N 17256036 N2836NGreat Planes Aviation Inc · Rochester, MNBuilt 1979 · S/N 28-7916461 N2836RWorthington David C Trustee · Saratoga, WYBuilt 1967 · S/N 18258436 N2836TRegistered aircraftBuilt 1972 · S/N 28-7225245 N2836USolymanbeyk Willard · Modesto, CABuilt 1963 · S/N 17250436 N2836YAyers Janet S · London, KYBuilt 1962 · S/N 18253836 N2837AGreen Tree Aviation LLC · Provo, UTBuilt 1979 · S/N 28-7921050 N2837CPerris Valley Skydiving School Inc · Perris, CABuilt 1954 · S/N 26380 N2837ELincoln Bruce · Lake Odessa, MIBuilt 1979 · S/N 28-7921052 N2837LGehrke Halle · Elk Mound, WIBuilt 1967 · S/N 17256037 N2837QChaffee Dean L · Weidman, MIBuilt 1971 · S/N 17259837 N2837THuffman Jacob M III · Burleson, TXBuilt 1972 · S/N 28-7225246 N2837UCamous Alain E · Sunrise, FLS/N 28R-7918166 N28381Hanscom Aero Club · Hanscom Afb, MABuilt 1979 · S/N 28-7916408 N2838DHis Promise Aviation Service Inc · Big Spring, TXBuilt 1979 · S/N 28-7916463 N2838FGordon Brennan L · Houston, TXBuilt 1979 · S/N 28-7916464 N2838KOrtman James W · Bozeman, MTBuilt 1979 · S/N 18053088 N2838LA-R-M Aircraft Leasing LLC · Williamsburg, VABuilt 1967 · S/N 17256038 N2838QAdriatic Holdings LLC · Cheyenne, WYBuilt 1971 · S/N 17259838 N2838RFairbanks Mark J · Kotzebue, AKS/N 18258438 N2838UCag Farms Inc · Angier, NCS/N 17250438 N2838WFreebird LLC · Leawood, KSBuilt 1973 · S/N CE-446 N2839AAldrich David S · Unity, MEBuilt 1953 · S/N 30039 N2839BGartman Henry L Sr · Moberly, MOBuilt 1979 · S/N 28-7990485 N2839CRegistered aircraftBuilt 1954 · S/N 26382

Back to AD 98-21-21 R1