Registered aircraft · 54,015

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N8328SAhrens Scott W · Castle Rock, COBuilt 1965 · S/N 18256428 N8328XPrevatt Richard T · Jacksonville, FLBuilt 1961 · S/N 17248828 N8329A170 Adventures LLC · Hermosa Beach, CABuilt 1952 · S/N 25181 N8329JWooley Eva · Hephzibah, GABuilt 1967 · S/N 15066229 N8329SWhite Plane LLC · Forest Lake, MNBuilt 1965 · S/N 18256429 N8329UVolkman Ary D · Waunakee, WIS/N 17252229 N832DCCase Daniel J · Spokane, WABuilt 1979 · S/N 17271180 N832PMCunningham William R · Broken Arrow, OKS/N 18258824 N832SRWallace John M · Canton, MSS/N 15062860 N8330AKoliadko Joseph I · Luray, VAS/N 25182 N8330TPerry Charlotte A · Pearland, TXBuilt 1961 · S/N 17557030 N8331GWhitley Jonathan K · Goldsboro, NCBuilt 1965 · S/N 15062431 N8331LMjl Investment Company Inc · Branchville, NJBuilt 1968 · S/N 17256531 N8331TPerry Loren D · Hephzibah, GAS/N 17557031 N8331ZProbasco Mitchell L · Floydada, TXBuilt 1963 · S/N 205-0331 N8332GFlack Kevin S · Woolford, MDBuilt 1965 · S/N 15062432 N8332SFlyit LLC · Camas, WABuilt 1965 · S/N 18256432 N8332UNeeley James L · Temecula, CABuilt 1964 · S/N 17252232 N8332XFlight Instruction Inc · Central City, NEBuilt 1961 · S/N 17248832 N8333GInvestair LLC · Conway, ARBuilt 1965 · S/N 15062433 N8333LLedford Daniel R · Granbury, TXBuilt 1968 · S/N 17256533 N8333XBrownlee Mark B · Helena, MTBuilt 1961 · S/N 17248833 N8334GAvcraft Inc · Columbus, NEFirst renewal noticeBuilt 1965 · S/N 15062434 N8334LAirspeed Marketing Bravo LLC · Phoenix, AZBuilt 1968 · S/N 17256534 N8334QVolatile Aero Ventures LLC · Boulder City, NVS/N U20603195 N8334SRecord John W · Apison, TNS/N 18256434 N8334THowe Danny · Camp Verde, AZBuilt 1961 · S/N 17557034 N8334UBrown Matthew D · Hamptonville, NCBuilt 1964 · S/N 17252234 N8334XBumgarner Tommy J · Stanley, NCBuilt 1961 · S/N 17248834 N8335AHaack Forrest · Wasilla, AKS/N 25187 N8335QFlying M Aviation LLC · Twin Falls, IDFirst renewal noticeBuilt 1978 · S/N 18503659 N8335TRegistration Pending · Greenleaf, WIRegistration pending, pending cancellationS/N 17557035 N8335UFaour Douglas M · Macon, GABuilt 1964 · S/N 17252235 N8335ZLorentzen Aaron · Sterling, AKBuilt 1963 · S/N 205-0335 N8336ANicholson Scott V · Kalamazoo, MIFirst renewal noticeBuilt 1952 · S/N 25188 N8336JGoat Rodeo Aviation LLC · Leesburg, INBuilt 1967 · S/N 15066236 N8336MStarz Align Aviation LLC · Marshfield, WIBuilt 1969 · S/N A1500036 N8336SGroff Bradley Gene · Kingston, OKBuilt 1965 · S/N 18256436 N8336TBernal Sergio R · Buckeye, AZBuilt 1961 · S/N 17557036 N8337GSkyline Aviation Inc · San Angelo, TXBuilt 1965 · S/N 15062437 N8337JGeorge Downer Flyers LLC · Aliceville, ALS/N 15066237 N8337UHaeffner Christopher M · Saint Peters, MOBuilt 1964 · S/N 17252237 N8337XMckay Jim · Camden, TNBuilt 1961 · S/N 17248837 N8338AWoodbury Forest P · Clarksville, TNBuilt 1952 · S/N 25190 N8338BSmitty172 LLC · Rockford, MIBuilt 1957 · S/N 36138 N8338LTreimer Aviation LLC · Davenport, IABuilt 1968 · S/N 17256538 N8338TOhair Mitchell · Temecula, CABuilt 1961 · S/N 17557038 N8338USchnell Brothers Aviation LLC · Kalispell, MTBuilt 1964 · S/N 17252238 N8338XSkiatook Flying Club LLC · Skiatook, OKBuilt 1962 · S/N 17248838 N8338ZNistler Ben · Bozeman, MTBuilt 1963 · S/N 205-0338

Back to AD 87-20-03 R2