OpenAirDocs.org
AD 98-21-21 R1

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
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.

N1852RHartman Craig T Trustee · Chugiak, AKBuilt 1975 · S/N 18502567N1852SReg Aeronatics LLC · Bradenton, FLBuilt 1981 · S/N E-1923N1852WDavis Sean · Carlisle, IABuilt 1973 · S/N TH-329N1852XPhillips Lane · Dawson, TXBuilt 1965 · S/N 18255952N1852YMinot Light Aviaiton LLC · Rockland, MABuilt 1962 · S/N 17249452N1853BAltius Aviation LLC · Syracuse, NYBuilt 1981 · S/N TC-2420N1853CDavidson Gregg C · Pioneer, CAFirst renewal noticeBuilt 1953 · S/N 25997N1853JSargent David W · Port Angeles, WABuilt 1968 · S/N 28-24290N1853QSend North · Anchorage, AKBuilt 1975 · S/N U20602943N1853WKozdron Henry · Harbor Beach, MIBuilt 1973 · S/N D-9477N1853YHurd Roger Mark · Bow, WABuilt 1962 · S/N 17249453N1854CBurns Linda J · Vernon, MIBuilt 1953 · S/N 25998N1854FHarlan Bradley J · New Brighton, MNBuilt 1966 · S/N 21058754N1854JM & D Aviation 2019 LLC · Ocklawaha, FLBuilt 1968 · S/N 28-24292N1854KNelson Law Firm Pc · Billings, MTBuilt 1981 · S/N E-1927N1854RSellers William G III · Troy, ALBuilt 1982 · S/N TH-1345N1854VSchmitt Rudy · Brookshire, TXBuilt 1974 · S/N 17263771N1854WRona-B LLC · Scottsdale, AZBuilt 1981 · S/N EA-269N1854YMikowski Charles A · Sparta, MIS/N 17249454N1854ZBargabos William M · Wasilla, AKS/N 2050054N1855CRowe James D · Nome, AKBuilt 1953 · S/N 25999N1855D55 Delta LLC · Jacksonville, FLBuilt 1952 · S/N D-3130N1855JNicholson John · Sapulpa, OKS/N 28-24293N1855S1855 Sierra LLC · Brighton, MIBuilt 1981 · S/N CE-980N1856DByrd Aviation LLC · Marshfield, MOS/N D-3112N1856EGv Air Inc · Medford, ORBuilt 1979 · S/N 310R1591N1856FCraig Marc · Mountain City, TXBuilt 1981 · S/N E-1931N1856HVieman John D · Owensville, MOBuilt 1959 · S/N 35956N1856JWood Dragon LLC · Portland, MEFirst renewal noticeBuilt 1968 · S/N 28-24294N1856LR J Fuselier & Associates LLC · Eunice, LABuilt 1976 · S/N D-9889N1856RRich Gary L · Anchorage, AKBuilt 1974 · S/N 18502571N1856XRobert Yost Enterprises · Saint Francis, KSBuilt 1964 · S/N 18255956N1856ZBromley Wayne B · Colwich, KSBuilt 1981 · S/N CE-977N1857CSchlender Michael E · Clintonville, WIBuilt 1953 · S/N 26001N1857JMulas Joseph Anthony · Chesterfield, VABuilt 1968 · S/N 28-24295N1857RNoetic Aviation LLC · Seattle, WABuilt 1978 · S/N R18200581N1857TDieck Michael John · Fayetteville, NCBuilt 1971 · S/N 28-7225006N1857VCare Central Inc · Minneapolis, MNS/N 17263772N1857YKnudson Wayne L · Larimore, NDBuilt 1962 · S/N 17249457N1858LAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N CE-646N1858PBaron N1858p LLC · Fresno, CABuilt 1981 · S/N TJ-372N1858XSalem Aero Club Inc · Bridgeton, NJBuilt 1964 · S/N 18255958N1858YBlaich George F IV · Poplar Bluff, MOBuilt 1962 · S/N 17249458N1858ZPairofminutes LLC · Marshville, NCS/N 205-0058N1859AAverett University · Danville, VABuilt 2022 · S/N 2881527N1859CHadley Aviation LLC · Kent, CTBuilt 1981 · S/N CE-986N1859FBaker Robert J · Ogema, MNBuilt 1966 · S/N 21058759N1859P1859p LLC · Fulton, MOBuilt 1982 · S/N E-1995N1859TPhil Harris Saddlery Inc · State Road, NCBuilt 1971 · S/N 28-7225009N1859WDellarosa Brian David · Indianapolis, INBuilt 1973 · S/N D-9503
Back to AD 98-21-21 R1