Registered aircraft · 85,616

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.

N107RHHenderson Robert T Jr · Sunny Isles Beach, FLBuilt 1977 · S/N R18200093 N107TANelson Sarah J · Anchorage, AKBuilt 1975 · S/N 32-7540099 N107TTBpi Labs Inc · Evanston, WYBuilt 1978 · S/N 310R1345 N107TYThornock Ty D · Shawano, WIS/N 18502836 N107VWHenning Nancy E · Hardinsburg, KYBuilt 1960 · S/N CD-71 N107WFWilcox Farms Inc · Roy, WABuilt 1961 · S/N 18253149 N107WSByers Mike L · Vista, CABuilt 1959 · S/N GH-107 N107YYBeezhold Terence J · Lake Stevens, WABuilt 1956 · S/N 35266 N10805Hill Ag-Air LLC · Pocatello, IDS/N 28-22677 N1080FWeitekamp Shawn Paul · Roanoke Rapids, NCBuilt 1979 · S/N 17272949 N1080HAll2fly LLC · Atlanta, GAS/N 28-7715306 N1080MFlying Particles Inc · Livermore, CABuilt 1977 · S/N 18266034 N1080PN41723 Partners LLC · Vienna, WVBuilt 1996 · S/N 24-3387 N1080STacoma Management Inc · Martinsville, VABuilt 1997 · S/N TH-1818 N1080UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020231 N1080WParks Robert Steven · Hayward, CAFirst renewal noticeBuilt 1973 · S/N CE-435 N1080XFlying With Fitch LLC · Porter, TXS/N 28-7525278 N10816Van Der Merwe Coenraad · Traverse City, MIBuilt 1968 · S/N 244753 N1081YWc LLC · Austin, TXBuilt 1996 · S/N E-3039 N1082FWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 17272950 N1082PGarrett James D Jr Trustee · Coolidge, AZBuilt 1968 · S/N 18258855 N1082XWhitmer Ronald N · Ellsworth, KSBuilt 1975 · S/N 28-7505207 N1082YCalvey Eric W · Abingdon, MDS/N 25-0582 N1083FKellogg Gretchen Garst · Mesa, AZS/N 24-3317 N1083LBenson Mark D · San Diego, CABuilt 1996 · S/N 24-3393 N1083QAhlhorn Travis W · San Marcos, TXBuilt 1963 · S/N 310H0083 N1083VWoltering Myron B · Granite Bay, CABuilt 1974 · S/N U20602453 N1083WAeolus Aircraft LLC · Seminole, OKS/N TH-323 N1084FSiktberg Timothy J · Nashville, TNFirst renewal noticeBuilt 1975 · S/N 18502739 N1084LMillet Alan E · Sequim, WABuilt 1996 · S/N 24-3394 N1084VEastwind 9 LLC · Dover, DEBuilt 1981 · S/N 24-1131 N10851Curran Michael F · Windham, NHS/N 25-1229 N10853St Johns Marine DBA · San Mateo, FLS/N 277854024 N1085CBentley Geoffrey D · Marco Island, FLBuilt 1990 · S/N 25-1228 N1085FSale Reported · Greenwood, INSale reported, pending cancellationBuilt 1979 · S/N 17272951 N1085MDuncan Terry C Trustee · Cupertino, CABuilt 1975 · S/N 18264221 N1085NWong Sonja M · Alameda, CABuilt 1981 · S/N 25-0583 N1085XCovington Guy P Sr · Centreville, MDBuilt 1994 · S/N 24-3323 N1086LLade Burton G · Bemidji, MNBuilt 1959 · S/N 50564 N1086MSargent John E · Vancouver, WABuilt 1975 · S/N 18264222 N1086QBarnhardt Paul · Madison, GABuilt 1990 · S/N 24-3168 N1086UHancock County Port & Harbor Commission · Kiln, MSBuilt 1976 · S/N 17266835 N1086WThomas R Cave Inc · San Jose, CABuilt 1996 · S/N EA-586 N1087SVolitation Ventures LLC · El Macero, CABuilt 1996 · S/N EA-587 N1088LLima Whiskey Ic LLC · Mertzon, TXBuilt 1995 · S/N E-2988 N1088UWestern Wyoming Aviation Services LLC · Pinedale, WYBuilt 1976 · S/N 17266837 N1089BDakota Territory Air Museum Inc · Minot, NDBuilt 1958 · S/N 1315 N1089CRegistered aircraftBuilt 1995 · S/N E-2989 N1089EAml Aviation LLC · Lexington, KYBuilt 1996 · S/N E-3030 N1089FWells Thomas J · Big Lake, AKBuilt 1975 · S/N 18502744

Back to AD 98-21-21 R1