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.

N1072QCoastal Air Inc · Groton, CTBuilt 1977 · S/N 28-7725180 N1072XDemaagd Ross E · Middleville, MIBuilt 1975 · S/N 28-7505206 N1073XAustin Arrows Inc · Austin, TXBuilt 1975 · S/N 28R-7535232 N1075RGeorgia Aviation Authority · Eastman, GABuilt 2006 · S/N 2843649 N1076QExecutive Flight Institute LLC · Murrieta, CABuilt 1977 · S/N 28-7790374 N1076XMarston Lester J · Ukiah, CABuilt 1975 · S/N 28-7515383 N1077XJny LLC · Riverview, FLBuilt 1975 · S/N 28R-7535234 N1079HJaremus Kent M · Olathe, KSS/N 28-7725131 N1079YBoyer Jerry D · Monument, ORBuilt 1962 · S/N 28-118 N107MRMeriden Aviation Center LLC · Meriden, CTBuilt 1977 · S/N 28-7816251 N107NDN107nd LLC · Wilmington, DEBuilt 1989 · S/N 2841214 N107TANelson Sarah J · Anchorage, AKBuilt 1975 · S/N 32-7540099 N10805Hill Ag-Air LLC · Pocatello, IDS/N 28-22677 N1080HAll2fly LLC · Atlanta, GAS/N 28-7715306 N1080UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020231 N1080XRegistration Pending · Houston, TXRegistration pendingS/N 28-7525278 N1082XWhitmer Ronald N · Ellsworth, KSBuilt 1975 · S/N 28-7505207 N1089XCoastal Aviation Partners LLC · Hubert, NCS/N 28R-7535236 N108AVDavis Robert S · Keystone Heights, FLBuilt 1974 · S/N 28-7415573 N108HWYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 2881997 N108LZNcb Realty LLC · Little Rock, ARBuilt 1978 · S/N 28R-7918014 N108NDMavity Michael D · Phoenix, AZBuilt 1990 · S/N 2841328 N108NSLyon Andrew L · Fairbanks, AKBuilt 1976 · S/N 32R-7680288 N108WMMoran William J · Media, PABuilt 1978 · S/N 32-7840187 N1090QArrow 051 LLC · Leicester, NCBuilt 1977 · S/N 28R-7703051 N1092TH4s Aviation LLC · Longview, TXS/N 28-25565 N1092XNice Curtis A · Lawrenceburg, INBuilt 1975 · S/N 28R-7535230 N1093XRoseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 28-7515386 N1094TGlover Anthony R · Louisville, KYBuilt 1969 · S/N 28R-31116 N10958Aero Quest LLC · Olive Branch, MSBuilt 2025 · S/N 28020251 N1095XVillegas Miguel Angel Cuello · Weston, FLBuilt 1975 · S/N 28R-7535239 N1096TEvans Charles B · Benbrook, TXS/N 28-26284 N1097THorizon Aviation LLC · Brooks, GABuilt 1969 · S/N 28-26287 N1099JLee'S Sea Air Inc · Kiana, AKBuilt 1967 · S/N 32-40274 N109ATAguillard Robert N · Memphis, TNBuilt 1974 · S/N 32-7540042 N109GPCash Management Consulting LLC · Granite Springs, NYBuilt 1977 · S/N 28-7816287 N109KBWings Aviation Inc · Valparaiso, INBuilt 1978 · S/N 28R7803043 N109LDEast Bay Flight LLC · Alameda, CABuilt 1979 · S/N 28-7990292 N109MBFirefly Aviation LLC · Midland, TXBuilt 1978 · S/N 32R-7887238 N109RBClark William R · Anchorage, AKBuilt 1965 · S/N 282612 N10ASCrewson Gary · East Aurora, NYBuilt 1972 · S/N 28R-7235196 N10GHPeters Darvin Leroy · Meservey, IAS/N 28-20482 N10JKZalan Aviation LLC · Cincinnati, OHBuilt 1978 · S/N 32R-7887242 N10PJMiller Kenneth R · Russellville, KYBuilt 1967 · S/N 32-40285 N10ZVThat 70s Plane Inc · Athens, GABuilt 1977 · S/N 32R-7780390 N1102NWorld Class Athletic Surfaces Inc · Leland, MSBuilt 1968 · S/N 32-40756 N1102XMarak Enterprises LLC · Galena, MOBuilt 1975 · S/N 28-7505210 N1103XHolmgren Joel A · Chisago City, MNBuilt 1975 · S/N 28-7515388 N1104HSkydance Aviation LLC · Chesapeake, VAS/N 28-7725132 N1107HShurtz William W Jr · Medford, ORBuilt 1977 · S/N 28-7715308

Back to AD 87-08-08 R3