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.

N115EL182 Flight Corp · Bronx, NYBuilt 1984 · S/N U20606814 N115HPCam Aviation LLC · Valparaiso, INBuilt 1998 · S/N 3246115 N115JAFarmer Stephen E · Tullahoma, TNBuilt 1967 · S/N 28-22953 N115JDC R Aviation Inc · Miami, FLS/N 27-7405395 N115KFMiles Matthew W · Havre, MTBuilt 1968 · S/N 18259010 N115KVKva Electric Inc · Arlington, WAS/N 18261214 N115MBChalet Suzanne Aviation Inc · Lake Wales, FLS/N 17248936 N115MRRussell Keith M · Ivoryton, CTBuilt 1960 · S/N D-6394 N115MSC And C LLC · Jacksonville, FLS/N 24-0031 N115NJUsda Forest Service Fepp · Trenton, NJBuilt 1966 · S/N 18256954 N115RFPeabody Riley A · Minnetonka, MNBuilt 1961 · S/N 17556810 N115RPN115rp LLC · Midland, TXBuilt 1977 · S/N 21061944 N115SDSky High Aviation LLC · Max, NDBuilt 1980 · S/N 250369 N115TWYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020133 N115WDWalton Paul L · Indianapolis, INBuilt 1972 · S/N TE-863 N115WEPhilips Robert Jay · Midlothian, TXBuilt 1976 · S/N TK-15 N11606N11606 Inc · Fort Lauderdale, FLBuilt 1982 · S/N 24-1276 N1160FOcala Aviation Services Inc · Ocala, FLS/N 17254755 N1160NChott W Andrew · Las Vegas, NVBuilt 1982 · S/N 24-1274 N1160UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020245 N1160XWagner Robert J · Dubuque, IABuilt 1975 · S/N 28R-7535261 N11615Sam Imaging LLC · Douglas, GABuilt 1982 · S/N 24-1279 N1161BDean William R · Webster Springs, WVBuilt 1982 · S/N 25-0661 N1161FBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 17254756 N1161HEngert Armin L · Kahului, HIBuilt 1976 · S/N 28-7715312 N1161MRed Climb Transition LLC · New York, NYBuilt 1982 · S/N 25-0657 N1161PN1161p LLC · Aspen, COBuilt 1982 · S/N 25-0658 N1161XBarnett Donald R · Atoka, TNBuilt 1975 · S/N 32-7500040 N1161ZSouthpoint Aviation LLC · Boca Raton, FLBuilt 1983 · S/N 24-1356 N1162DUniversal Pacific Investments Corp · Portland, ORBuilt 1983 · S/N 25-0730 N1162GLores Fernando Augusto · S San Francisco, CABuilt 1982 · S/N 24-1281 N1162XSeeding Operations And Atmospheric Reseach LLC · San Angelo, TXBuilt 1975 · S/N 34-7570225 N1163ADodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 25-0666 N1163BCeltic Aviation LLC · Kalispell, MTBuilt 1982 · S/N 25-0667 N1163FMid-Tenn Aero Club Inc · Franklin, TNBuilt 1979 · S/N 17272962 N1163GRusson Tyler G · San Carlos, CABuilt 1982 · S/N 24-1292 N1163TIrish Aviation Inc · Orlando, FLBuilt 1975 · S/N TE-1033 N1163XPerry Curtis · Klamath Falls, ORS/N 28-7515396 N1163ZHayes Dennis M · Fort Myers, FLBuilt 1982 · S/N 24-1285 N1164GGolonka Bryan · Locust Grove, GABuilt 1982 · S/N 25-0677 N1164WBeaver Brook Aviation LLC · Scotia, NYBuilt 1967 · S/N TE-400 N1164XRegistered aircraftBuilt 1975 · S/N 28R-7535263 N1165DFlight Management Group LLC · Wadsworth, OHBuilt 1981 · S/N 25-0640 N1165GBreason Enterprises LLC · Dover, DEBuilt 1982 · S/N 25-0685 N1165LFlodine James B · Houston, TXBuilt 1982 · S/N 24-1295 N1165MArsene Eddy R · Lynnwood, WAS/N 18264237 N1165NAbbott Jason · Hendersonville, TNBuilt 1983 · S/N 24-1350 N1165TFlying J Partners Asset Management LLC · Casper, WYBuilt 1975 · S/N D-9754 N1165UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17266872 N1165WGlobal Net Designs LLC · Marina Del Rey, CABuilt 1982 · S/N 24-1341

Back to AD 98-21-21 R1