Registered aircraft · 72,010

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.

N412SCMay Bob L · Wedowee, ALBuilt 1946 · S/N 12-868 N412TGThompson Larry N · Artesia, NMBuilt 1970 · S/N 32-40916 N412TMFlying J Aviation LLC · Sargent, NES/N 31-510 N412WKDuncan William T Jr · Virginia Beach, VABuilt 2003 · S/N 25855 N412WSArnold Jerry W · Lincoln, NEBuilt 1970 · S/N 17701475 N413Shearer John W · The Dalles, ORBuilt 1988 · S/N 32848 N41306Bruns Darcy · Sandia, TXBuilt 1969 · S/N 17258310 N4130JOur Space Properties LLC · Camdenton, MOBuilt 1966 · S/N 28-22451 N4130NCentral Irrigation Supply Co · Watsonville, CABuilt 1998 · S/N 2843171 N4130PKoch William L · Barre, VTBuilt 1959 · S/N 23-1610 N4130RMaverick Hunter Airlines LLC · Stuart, FLBuilt 1968 · S/N 32-40448 N41316Elliott Barry E · Lake Havasu City, AZBuilt 1974 · S/N 28-7415168 N41318Bailey Jeffrey R · Indianapolis, INBuilt 1974 · S/N 28-7415169 N4131JTomb Randall H Jr · Pittsburgh, PAFirst renewal noticeBuilt 1966 · S/N 28-22453 N4131LRegistration Pending · Norwalk, CTRegistration pendingBuilt 1998 · S/N 3257068 N4131UInter American University Of Puerto Rico · Bayamon, PRBuilt 1998 · S/N 2843199 N4131VBened Enterprises LLC · Jensen Beach, FLBuilt 1998 · S/N 3246120 N4131WRudd Joshua A · Cresson, TXBuilt 1967 · S/N 32-40197 N4131XElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1968 · S/N 230 N4131ZMacarthur Clinton W · Anchorage, AKBuilt 1965 · S/N 18-8201 N41320Dutchyshyn Harry V Jr · Pasadena, MDBuilt 1974 · S/N 28-7405092 N41327Sharp Penny E · Ocala, FLBuilt 1974 · S/N 28-7415171 N4132DDominguez Luis · Brownsville, TXBuilt 1999 · S/N 2843234 N4132JDubois Aviation Inc · Chino, CABuilt 2001 · S/N 28-22454 N4132WTopken William F · Fallon, NVBuilt 1967 · S/N 32-40198 N4132YMartin Beaux R · Calhoun, LAS/N 234-76 N41331Heath Andrew · Lafayette, INBuilt 1974 · S/N 28R-7435169 N41335Doherty Gordon W Jr · Garden Plain, KSBuilt 1974 · S/N 32-7440083 N4133EHouse Larry A · Anchorage, AKBuilt 1978 · S/N 18-7809129 N4133GAmsg Transport LLC · Bloomfield Hills, MIBuilt 1998 · S/N 4636186 N4133PCoulson Michael D · Zanesville, OHBuilt 1959 · S/N 23-1613 N4133RFlying Friends LLC · Lynchburg, VABuilt 1968 · S/N 32-40450 N4133WHochstedler Wilford L · Parsons, KSBuilt 1967 · S/N 32-40199 N4133XAnfuso Keith · La Habra Heights, CAS/N 232 N41342Papoutsis Thomas J · Chambersburg, PAS/N 28-7405094 N41343Lkr Aviation LLC · Buckeystown, MDBuilt 1974 · S/N 28R-7435171 N41348Low George D · Newport, MIBuilt 1974 · S/N 28-7425227 N41349Minot Aero Center · Minot, NDBuilt 1974 · S/N 28-7415179 N4134BWildrose Aviation LLC · Victor, CABuilt 1974 · S/N 74-31102 N4134DScull Timber Co Inc · Tenaha, TXBuilt 1998 · S/N 3257070 N4134JPriebe Aviation LLC · Waseca, MNBuilt 1966 · S/N 28-22456 N4134MHansen Kirk · Bayside, WIBuilt 1998 · S/N 3246124 N4134TDavis Stephen · Madera, CABuilt 1999 · S/N 2843206 N4134ZHuseby Terry L · Hulett, WYBuilt 1964 · S/N 18-8207 N41357Air Trek North LLC · South Saint Paul, MNBuilt 1974 · S/N 28-7425228 N41359Ayubi-Moak Jason S · Chandler, AZBuilt 1974 · S/N 28-7415184 N4135DChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 2843219 N4135JValiair Limited Company Trustee · Casper, WYS/N 3246127 N4135QRegistration Pending · Lenoir City, TNRegistration pendingBuilt 1977 · S/N 32R-7780329 N4135RHinkle Robert J · Caldwell, IDBuilt 1968 · S/N 32-40452

Back to AD 87-10-06 R1