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.

N112WSEdgeington Randall K · Riverton, WYBuilt 1961 · S/N 24-2765 N112WWAmerican Smooth Aviation LLC · Rock Hill, SCFirst renewal noticeBuilt 1977 · S/N 310R1215 N112XAir Corriente LLC · Columbia, TNBuilt 1966 · S/N D-8121 N1130FMonahan William T · Vestal, NYBuilt 1966 · S/N 17254725 N1130MTelbo LLC · Vonore, TNBuilt 1965 · S/N D-8023 N1130QHedges William S · Algona, IABuilt 1997 · S/N EA-598 N1130UTc Aviation LLC · Denham Springs, LAS/N 17266859 N1131MWhite Tom · South Charleston, WVBuilt 1975 · S/N 18264228 N1131PDBA Congdons Aviation Service · Anchorage, AKS/N 23-141 N1131QFarm Country Air LLC · Jefferson, IABuilt 1977 · S/N 28R-7703053 N1131WPrice Steven D · Healdsburg, CABuilt 1976 · S/N 18264584 N1132PR & S Stuart Co Inc · Wilmington, DEBuilt 1955 · S/N 23-142 N1132QWattum Investments LLC · Kodiak, AKBuilt 1977 · S/N 32-7740046 N1132UMjolhus Knut G · Amarillo, TXBuilt 1982 · S/N 21064669 N1133APedota Darien · Northport, ALBuilt 1980 · S/N CE898 N1133FFinnelly Barry J · Snohomish, WABuilt 1966 · S/N 17254728 N1133QHaggard Haley G · Springer, OKBuilt 1963 · S/N 310H0133 N1133UMustachio Donald · East Stroudsburg, PABuilt 1976 · S/N 17266862 N1133XBristol Aircraft Leasing LLC · Willoughby, OHBuilt 1967 · S/N 670504 N1134ABeaver Creek Aviation LLC · Clinton, OKBuilt 1997 · S/N E-3066 N1134FScialabba John E · Columbus, OHBuilt 1966 · S/N 17254729 N1134PSutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 23-146 N1134QFalyers Inc · Prairie Du Chien, WIS/N 32R-7780224 N1134UWells William L · Santa Cruz, CABuilt 1976 · S/N 17266863 N1134WAbs Aviation LLC · Cleveland, TNFirst renewal noticeBuilt 1997 · S/N E-3067 N1134XWard Bernard Holman III · Wichita Falls, TXBuilt 1997 · S/N E-3074 N1135FLong Duane C · Baskin, LAS/N 17272961 N1136ARegistered aircraftBuilt 1980 · S/N E-1694 N1136GBurnside Thomas L · Kansas, ILBuilt 1978 · S/N 18266300 N1136NPga Re LLC · Midland, TXBuilt 1996 · S/N E-3053 N1136PBjmj LLC · Greensboro, NCBuilt 1996 · S/N E-3044 N1136SBig Sky Beech LLC · Red Oak, IABuilt 1996 · S/N E-3054 N1136VN1136v LLC · Sheridan, WYBuilt 1996 · S/N EA-592 N1136YBonanza Aviation Inc Trustee · Wilmington, DEBuilt 1996 · S/N E-3050 N1137FWisti James G · New Hudson, MIBuilt 1966 · S/N 17254732 N1137MN1137m LLC · Bentonville, ARBuilt 1977 · S/N 21061921 N1137UFoscap Air LLC · Las Vegas, NVBuilt 1976 · S/N 17266866 N1137ZHighrize Aviation LLC · Marysville, KSS/N 24-1628 N1138FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 28R35260 N1138JEngebretsen Dale G · Moyock, NCBuilt 1981 · S/N 24-1144 N1138NSmazenka Robert L · Long Beach, CABuilt 1981 · S/N 24-1146 N1138PYs Pharmtech · San Diego, CABuilt 1981 · S/N 24-1147 N1138XPierce Nathaniel Antonio · Magnolia, DEBuilt 1975 · S/N 28R-7535256 N1139FGifford Kenneth A · Appleton, WIBuilt 1966 · S/N 17254734 N1139GDodds Earle K · Manville, NJBuilt 1981 · S/N 24-1151 N1139LMathewson Crews Aviation LLC · Indianapolis, INBuilt 1980 · S/N 32R8029091 N1139MMarshall J B · Talbott, TNBuilt 1975 · S/N 18264230 N1139PBieler Robert A · Carlsbad, CABuilt 1981 · S/N 24-1153 N1139UFettig Peter J · Bismarck, NDBuilt 1976 · S/N 17266868 N1139YPressley Brent DBA · Morristown, TNBuilt 1981 · S/N 24-1154

Back to AD 98-21-21 R1