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.

N171DFDkg Motorized Conveyances Inc · Beaverton, ORBuilt 1978 · S/N TJ-155 N171EPAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841209 N171ESFenton Richard R Trustee · Mckinleyville, CABuilt 1972 · S/N 18260964 N171FBrassell Andrew Keith · Argyle, TXBuilt 1964 · S/N TC-609 N171FBBiggs Aircraft Inc · Wellston, OKBuilt 1977 · S/N TC-2039 N171GStockwell Donald C · Westport, MABuilt 1978 · S/N 32R-7885241 N171HTodd Doug · De Witt, IABuilt 1965 · S/N D-7959 N171JTropicaire LLC · Hamilton, MTBuilt 1965 · S/N D-7957 N171JBAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1968 · S/N 28R-30756 N171JDStoffel Duane L · Hamilton, MTBuilt 1961 · S/N TC-90 N171KSVida Vibrante LLC · San Juan, PRBuilt 1979 · S/N 21063167 N171MHEvolution Solid LLC · Salem, ORBuilt 1981 · S/N R182-01766 N171PPiper Aircraft Inc · Vero Beach, FLS/N 28020291 N171PBHarding Derrick S DBA · Adair, OKBuilt 1995 · S/N E2992 N171PFRegistration Pending · Los Osos, CARegistration pendingBuilt 1980 · S/N EA-164 N171RMMckinney Mark · Meadowview, VABuilt 1972 · S/N U20601938 N171RPRosales Partners Air LLC · Austin, TXBuilt 1977 · S/N D-10092 N171RSSeneque USA Inc · West Palm Beach, FLBuilt 1980 · S/N U20605558 N171SKHuddleston Edward · Oaktown, INBuilt 1980 · S/N 17273857 N171TMG&L Aviation Services LLC · Las Vegas, NVBuilt 1980 · S/N 21063894 N171TWRsj Aviation LLC · Winston Salem, NCBuilt 1984 · S/N 32R-8413019 N171VAEckles Aircraft LLC · Holdenville, OKBuilt 1979 · S/N 17272239 N171WAKessenich Kimberly D · Montello, WIBuilt 1973 · S/N 287305592 N171WBYeager Hal J · Winterset, IABuilt 1975 · S/N 18264036 N171XLifto Patrick J · Miles City, MTBuilt 1962 · S/N D-5857 N171YCesarano Billy · Maryville, TNBuilt 1958 · S/N D-5467 N1720DDriver Jonathan S · Oakland Park, FLBuilt 1951 · S/N 20163 N1720GRegistration Pending · Kalispell, MTRegistration pending, pending cancellationBuilt 1962 · S/N D-6943 N1720TLumi Wings Corp · Goodyear, AZBuilt 1970 · S/N 28-7125033 N1720XKregel Brian D · Garnavillo, IABuilt 1975 · S/N 21060742 N1720ZBend Aircraft Mechanics LLC · Bend, ORBuilt 1977 · S/N 17269397 N1721CLemons Air LLC · Boulder, COS/N 30421 N1721FCenterline Flying Club Inc · Williamstown, NJBuilt 1966 · S/N 17255116 N1721GCorlett Samuel E · Fort Worth, TXBuilt 1962 · S/N D-6944 N1721RStecher Allan · Thornton, COBuilt 1978 · S/N R18200534 N1722CA G Sholton Co · Wasilla, AKBuilt 1953 · S/N 30422 N1722FLeone William T II · Canfield, OHBuilt 1966 · S/N 17255117 N1722HWashington State Community College · Spokane, WABuilt 1959 · S/N 35822 N1722JDonah Thomas J · Plattsburgh, NYBuilt 1968 · S/N 28-24134 N1722TNoldin John · Griffith, INS/N D-7139 N1723BBoyko George · Tarpon Springs, FLBuilt 1979 · S/N 206-05190 N1723CDi Gangi Stephen S · Spokane, WABuilt 1953 · S/N 30423 N1723GDillahunty Chris D · Shaver Lake, CAS/N CD-486 N1723HCo-Operative Cross Roads Flying Club · Albuquerque, NMBuilt 1977 · S/N 32R-7780187 N1723VRay Alan G · Oklahoma City, OKS/N 17263725 N1724CLentz Walter E · Duncan, OKBuilt 1953 · S/N 30424 N1724FWalters Todd J · Darwin, MNBuilt 1966 · S/N 17255119 N1724GNelson Debra L · Presque Isle, MEBuilt 1962 · S/N CD-487 N1724JKeeven Diana F · Hawk Point, MOBuilt 1968 · S/N 28-24136 N1724KN1724ken LLC · Minocqua, WIBuilt 1971 · S/N 17260235

Back to AD 98-21-21 R1