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.

N1820VAsp Kenneth · Thief River Falls, MNBuilt 1974 · S/N 17263762 N1820ZStaats Douglas E · Anchorage, AKBuilt 1962 · S/N 205-0020 N18218All Spark Aviation LLC · Naples, FLBuilt 1978 · S/N R18200209 N1821DBowman Kent · Rexburg, IDS/N D-3090 N1821EHth Companies Inc · Union, MOBuilt 1979 · S/N 310R1581 N1821FAlexander Travis · Hudson Oaks, TXS/N 21058721 N1821JWebber Alvin G · Bella Vista, ARS/N 28-24252 N1821RHoward Todd R · Minneapolis, MNBuilt 1974 · S/N 18502536 N1821SBailey Ralph E · Sikeston, MOBuilt 1962 · S/N 2050021 N1821WModern & Classic Aviation LLC · North Royalton, OHBuilt 1973 · S/N TC-1522 N1821XCluer Brian L · Bodega, CABuilt 1964 · S/N 18255921 N1821YKinney James R · Vermillion, SDBuilt 1962 · S/N 17249421 N1822CBrouwer Aviation LLC · Kalamazoo, MIBuilt 1974 · S/N 18262981 N1822HAdvanced Aviation Group LLC · Frederick, MDBuilt 1977 · S/N 28-7790345 N1822JWright Debra A · Avondale, PABuilt 1968 · S/N 28-24253 N1822NMars Michael Morrow · Collierville, TNBuilt 1981 · S/N D-10377 N1822ROney Tony K · Anchorage, AKBuilt 1974 · S/N 18502537 N1822SSnider Nancy J · Washington, DCBuilt 1981 · S/N TC-2357 N1822WLawrence Kevin M · Meridian, MSBuilt 1973 · S/N D-9424 N1822ZAhrens Kevin Michael · Cashmere, WABuilt 1962 · S/N 205-0022 N1823AKearns Adam · Portland, ORBuilt 1972 · S/N 18260858 N1823JFroman Michael J · Mayer, MNBuilt 1968 · S/N 28-24254 N1823RJones Alfred J · Friendsville, PABuilt 1974 · S/N 18502538 N1823TShowalter Joshua J · Dougherty, IABuilt 1971 · S/N 28-7125206 N1823WMuhler Wayne · Brighton, COS/N TC-1509 N1823XN1823x LLC · Middletown, DEBuilt 1964 · S/N 18255923 N1824Luvara Michael S · San Jose, CABuilt 1970 · S/N 18260285 N18246Radial-Air Leasing Inc · Caro, MIBuilt 1977 · S/N CE-720 N1824AVesper David G · Ashland, OHBuilt 1970 · S/N 18260221 N1824CFindlay Mark W · Anchorage, AKBuilt 1953 · S/N 25968 N1824GHarkness Michael D · San Luis Obispo, CABuilt 1977 · S/N 18265819 N1824HAthar Glenola LLC · Mars, PABuilt 1977 · S/N 28-7790346 N1824NMaiorana Anthony J Trustee · Clarkston, WABuilt 1981 · S/N EA-248 N1824RKleissas Constantine · Wye Mills, MDBuilt 1978 · S/N R18200573 N18253Glass Anthony A Trustee · Plano, TXBuilt 1977 · S/N E-1067 N18256Registered aircraftBuilt 1956 · S/N 33605 N1825LBonanza Flying Club LLC · Ogden, UTBuilt 1976 · S/N D-9877 N1825QCree William H III · Long Beach, CABuilt 1977 · S/N 18503492 N1825RKincaid James B · Wasilla, AKBuilt 1974 · S/N 18502540 N1825SEngebretson Christopher D · Greenville, INS/N E-1898 N1825YRound Engine Aero · Nashville, MIS/N 17249425 N1825ZGreentek Inc · Oroville, CABuilt 1962 · S/N 205-0025 N18265Strance Gordon M · Sevierville, TNBuilt 1987 · S/N E-2381 N18266Underwood Gary · Lewisville, TXBuilt 1966 · S/N 18257115 N18269International Aviation Group LLC · Lake Wales, FLBuilt 1959 · S/N 23-1705 N1826JPope County Aviation LLC · Russellville, ARBuilt 1968 · S/N 28-24257 N1826LRhr Management Inc · Bancroft, WIBuilt 1976 · S/N E-845 N1826TBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 28-7105105 N1826VBig Blue Sky Aero LLC · Austin, TXBuilt 1997 · S/N E-3086 N1826WOzark Mountain Airways LLC · Springfield, MOBuilt 1973 · S/N TC-1510

Back to AD 98-21-21 R1