Registered aircraft · 72,001

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-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N21228Atp Aircraft 4 LLC · Wilmington, DEBuilt 1978 · S/N 44-7995043 N2122DS/S Systems LLC · Roca, NEBuilt 2016 · S/N 40914 N2122GDavid Mieding Trustee · Reno, NVBuilt 1978 · S/N 32R-7985055 N2122JCharles City Aeronautics Inc · Charles City, IABuilt 1978 · S/N 28-7916199 N2122KKnight Paul · Kawkawlin, MIBuilt 2024 · S/N 2024PK N2122LWare Pat · Farwell, TXFirst renewal noticeBuilt 1978 · S/N 28-7990257 N2122NOwen Jason Ryan · Fort Irwin, CABuilt 1979 · S/N 28R-7918039 N2122RAdventure North Flying Service LLC · Aitkin, MNS/N 28-5464 N2122WRegistration Pending · Ubly, MIRegistration pending, pending cancellationS/N M-1495 N2122ZObrien Air LLC · Prescott, AZBuilt 2004 · S/N T18208242 N21237Parker Jeff · Chelsea, ALBuilt 1974 · S/N 17263911 N2123AItechnology Design Inc · Gypsum, COBuilt 1978 · S/N 28-7990105 N2123EDream Flights LLC · Brewton, ALBuilt 2004 · S/N 18281331 N2123KStone Kent H · Franklin, TNBuilt 1979 · S/N 28-7990238 N2123MPapadopoulos Dimitris Alexander · Dallas, TXBuilt 1979 · S/N 28R-7918034 N2123TMy Way Aviation LLC · Weston, FLS/N 28R-7135066 N2123WSimmons Aeronautical LLC · Springfield, MOBuilt 1973 · S/N M-1496 N21246Eastern Stearman Inc Trustee · Leesburg, VAS/N 17263914 N21249Western Kentucky Petroleum Inc · Osage Beach, MOS/N 17263916 N2124FHesseltine Robert J · Grand Terrace, CABuilt 1978 · S/N 28-7916173 N2124JDomas Jeffrey P · Mankato, MNBuilt 1978 · S/N 28-7916201 N2124NLivestock Service Inc · Douglas, AZBuilt 1951 · S/N 18-259 N2124WSerra Joseph I · Inverness, FLBuilt 1973 · S/N M-1497 N2125ACable Thomas G · Rockford, MIBuilt 2003 · S/N 18281230 N2125KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1997 · S/N 27-0239 N2125MNfh Aviation LLC · Pikeville, KYBuilt 2000 · S/N 17280905 N2125TBasquit Kenneth · Pittsburgh, PAS/N 28R-7135068 N2125VGallagher Stephen · Delray Beach, FLBuilt 1977 · S/N 32R-7780431 N2125WWittmer Daniel J · Tucson, AZBuilt 1973 · S/N M-1499 N21262Aysta Nathan P · Hermantown, MNBuilt 1968 · S/N 130 N2126JChristie Ian A H · Limon, COS/N HB007 N2126WFormanek Carl F · Glen Flora, WIBuilt 1974 · S/N M-1502 N2126XCandace A Learned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 44-7995273 N21272Eagle Aviation Inc · Tucson, AZBuilt 1974 · S/N 17263920 N21279Kerry Air LLC · Wilmington, DEBuilt 2016 · S/N 2448 N2127ALockhart Michael Orian Jr · Altus, OKBuilt 1978 · S/N 32R-7985002 N2127DMetro Aircraft Co · Bloomington, MNBuilt 1978 · S/N 447995131 N2127GKneeshaw Donald J · Gilbert, AZBuilt 1978 · S/N 32R-7987079 N2127PDerbenwick Gary F · Colorado Springs, COBuilt 1979 · S/N 28-7990291 N2127RCohen Blanche F · Aurora, COBuilt 1969 · S/N 28-5465 N2127TGeiger Glenn M · Cincinnati, OHBuilt 1971 · S/N 28R-7135070 N21281Horne Randall W · Millington, TNBuilt 1972 · S/N 18261535 N21288Cunningham Campers Inc DBA · Clarksville, INBuilt 1978 · S/N 28-7990040 N21289High Flight Academy LLC · Allison Park, PABuilt 1974 · S/N 17263923 N2128CStrite Logan Dean · Robbins, NCS/N 473 N2128EFly For Fun LLC · Rockville, MDBuilt 1978 · S/N 17271165 N2128WDelgado David A · Fallbrook, CABuilt 1973 · S/N M-1504 N2128XWnc Aviation LLC · Arden, NCBuilt 1979 · S/N 44-7995276 N2128YE-Cubed Industries LLC · Big Piney, WYBuilt 2003 · S/N T18208206 N21295Tauscher Robert C · Friday Harbor, WABuilt 1974 · S/N 17263925

Back to AD 87-10-06 R1