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.

N1389FBedford Aero Club Inc · Bedford, INS/N 17254884 N1389HDouble Dd Arrow Aviation LLC · Graham, TXS/N 28R-7703024 N1389TR And S Flying LLC · Westfield, MABuilt 1972 · S/N 28-7205292 N1389ZNachtigal Joel K · Bulverde, TXBuilt 1961 · S/N D-6814 N138ADDance Carlton Spencer · Center, TXBuilt 1991 · S/N CE-1638 N138BCUniversidad Interamericana De Puerto Rico · Bayamon, PRBuilt 2003 · S/N 2843580 N138BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881955 N138FCUsda Forest Service Fepp · Tallahassee, FLBuilt 1982 · S/N 28-8290102 N138GGardiner Alan H · Waterford, CTBuilt 1964 · S/N D-7564 N138PBSouth Delta Aviation Inc · West Helena, ARBuilt 1980 · S/N TJ-273 N138PLCpg Air LLC · Skaneateles, NYBuilt 1986 · S/N TJ-482 N138QKyff Jeffrey V · Traverse City, MIBuilt 1964 · S/N TC-612 N138RA & K Aviation LLC · Wenatchee, WABuilt 1972 · S/N 317300935 N138SFUnderwood Mark A · Kennewick, WAS/N 28-20998 N138SWQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 18265569 N138TOnderko George C · Fairmont, WVBuilt 1950 · S/N D-2566 N138TLHarvest International Ministries Inc · Texarkana, ARBuilt 1981 · S/N TJ-362 N138TPTwo Pauls LLC · Forked River, NJBuilt 1968 · S/N 28-25301 N138TWSulka Andrew Mark · Pittsburgh, PABuilt 1974 · S/N D-9647 N138VAMysky LLC · Saint Louis, MOBuilt 2023 · S/N 28020112 N138WWCutler Christopher P · Whitewright, TXBuilt 1954 · S/N 26189 N13901Masscotte Michael · Mansfield, MABuilt 1970 · S/N 27-4533 N13902Campbell Travis G · Starr, SCBuilt 1974 · S/N 17263035 N13905Positive Rate LLC · Rutherford, NJBuilt 1974 · S/N 17263036 N1390TAccessible Aviation Inc · Tupelo, MSBuilt 1972 · S/N 34-7250274 N1390YMarshall Greg J · Alexandria, VABuilt 1961 · S/N 17249090 N1390ZGm Aviation LLC · Woodridge, ILBuilt 1961 · S/N D-6833 N1391SWysong Charles J · Hickory, NCFirst renewal noticeBuilt 1976 · S/N 18264952 N1391TAbita Air LLC · Covington, LABuilt 1972 · S/N 32-7240117 N1391UArctic Winds Inc · King Salmon, AKS/N 17267062 N13923Timoszyk James S · Wayne, MIBuilt 1974 · S/N 17263039 N1392DChalender Robert Christopher · Cocoa, FLS/N 19968 N1392SAbc Flying Club Inc · West Mifflin, PABuilt 1976 · S/N 18264953 N1392WSale Reported · Lakeland, FLSale reportedBuilt 1964 · S/N 2670 N1392YDoty Douglas C · The Dalles, ORBuilt 1961 · S/N 17249092 N1392ZRautiola Charles A · Rosemount, MNBuilt 1961 · S/N D-6822 N13938Seattle Offshore Dmi Inc · Bothell, WAS/N 17263041 N1393EMossler Jonathan E · Edgewater, FLBuilt 1978 · S/N 17270983 N1393FBenham John D · Blanco, TXBuilt 1975 · S/N 18502840 N1393PSeymour Lori L · Woodstock, GAS/N 23-445 N1393USelim Shahir P · Hollywood, FLBuilt 1976 · S/N 17267064 N1393YHall Bret C · West Plains, MOBuilt 1962 · S/N 17249093 N1393ZSdd LLC · Great Falls, MTBuilt 1961 · S/N D-6813 N13941Wings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263044 N13942Rohrer Mary · Fredericksburg, TXBuilt 1974 · S/N 17263045 N13943Tell Christopher A · Colville, WAS/N 17263046 N13944Ripp Ted · Pulaski, TNBuilt 1974 · S/N 17263047 N13946Air Capital Aviators Club · Wichita, KSBuilt 1974 · S/N 17263048 N1394FWeller Fred R · Saint Augustine, FLBuilt 1966 · S/N 17254889 N1394SGoodman Donald J · Bellingham, WABuilt 1976 · S/N 18264955

Back to AD 98-21-21 R1