Registered aircraft · 22,428

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:87-08-08-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3') 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:87-08-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  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:87-08-08-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
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.

N1131QFarm Country Air LLC · Jefferson, IABuilt 1977 · S/N 28R-7703053 N1132QWattum Investments LLC · Kodiak, AKBuilt 1977 · S/N 32-7740046 N1134QFalyers Inc · Prairie Du Chien, WIS/N 32R-7780224 N1138FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 28R35260 N1138XPierce Nathaniel Antonio · Magnolia, DEBuilt 1975 · S/N 28R-7535256 N1139LMathewson Crews Aviation LLC · Indianapolis, INBuilt 1980 · S/N 32R8029091 N113EJIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7715075 N113GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881455 N113HMAkins Tal M · Register, GABuilt 1976 · S/N 32-7640084 N113JCMcdonnell Bryant E · Boulder, COBuilt 1982 · S/N 28-8211027 N113KRIal Corp · Lewes, DEBuilt 1974 · S/N 28-7415211 N113SWFargo Jet Center LLC · Fargo, NDBuilt 1977 · S/N 28-7890298 N113TRBell Thomas E · Henniker, NHBuilt 1976 · S/N 32R-7680207 N113VKHaskell Brenton · Georgetown, KYBuilt 1978 · S/N 28R-7803352 N113WYRyals Barry · Rhine, GABuilt 1974 · S/N 28R-7535055 N1140QLuken Henry G III · Chattanooga, TNS/N 28-7716086 N1140XReaper LLC · Britton, MIBuilt 1975 · S/N 32-7540147 N1142QSteely Paul · Williamsburg, KYBuilt 1977 · S/N 28-7790378 N1144XFly Texas Sky LLC · Arlington, TXBuilt 1975 · S/N 28-7505215 N1144ZBay Lux Ventures LLC · Tampa, FLBuilt 1977 · S/N 287890231 N1146HLtk Air Inc · North Wilkesboro, NCBuilt 1976 · S/N 32-7740031 N1147HSpacious Skies LLC · Overland Park, KSBuilt 1977 · S/N 32R-7780139 N1147XPax Flyers LLC · Hollywood, MDBuilt 1975 · S/N 28R-7535259 N114CFAw Chartering LLC · Franklin, TNBuilt 1974 · S/N 28-7505080 N114ELNaperville Flying Club · Woodridge, ILBuilt 1981 · S/N 32-8106096 N1150XVenture North Aviation LLC · Cloquet, MNBuilt 1975 · S/N 28-7515394 N1154XKelley Jay D · Lake Havasu City, AZS/N 32-7540149 N1157XAscend Aviation LLC · Bountiful, UTBuilt 1975 · S/N 28-7525294 N1158HOs Flight LLC · Double Springs, ALS/N 28-7715311 N1159XBarrett Tyler J · Cullman, ALS/N 28-7505217 N115CSBurger Aviation LLC · Brandon, MSBuilt 2000 · S/N 32-46177 N115DCLong Jerry D · Solvang, CABuilt 1973 · S/N 28R-7335405 N115DXPiper Aircraft Inc · Vero Beach, FLS/N 28010102 N115HPCam Aviation LLC · Valparaiso, INBuilt 1998 · S/N 3246115 N115JAFarmer Stephen E · Tullahoma, TNBuilt 1967 · S/N 28-22953 N115TWYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020133 N1160UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020245 N1160XWagner Robert J · Dubuque, IABuilt 1975 · S/N 28R-7535261 N1161HEngert Armin L · Kahului, HIBuilt 1976 · S/N 28-7715312 N1161XBarnett Donald R · Atoka, TNBuilt 1975 · S/N 32-7500040 N1163XPerry Curtis · Klamath Falls, ORS/N 28-7515396 N1164XRegistered aircraftBuilt 1975 · S/N 28R-7535263 N1165XLechtenberg Lance · El Dorado, KSBuilt 1975 · S/N 32-7540150 N1167XHoover Adam A · Sugarloaf, PABuilt 1975 · S/N 28-7525295 N1168HKoplow Steve Alan · Sevierville, TNS/N 28R-7703015 N1168XJz Air LLC · Brooklyn, NYBuilt 1975 · S/N 28-7505219 N116AVValleortiz Hector J · Laurel Hill, NCBuilt 1984 · S/N 28-8416094 N116BKDacy Roy W · Rockport, TXS/N 32-782 N116FRCloverfield Aero LLC · Los Angeles, CABuilt 2014 · S/N 2844150 N1177AN1177a LLC · Lewes, DEBuilt 1977 · S/N 32R-7780430

Back to AD 87-08-08 R3