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.

N8166TPakan John S Trustee · Wasilla, AKBuilt 1960 · S/N 17556866 N8166XWells Clinton M · Cincinnati, IABuilt 1961 · S/N 17248666 N8166ZBronson Robert D Trustee · Prineville, ORBuilt 1962 · S/N 2050166 N8167LVan Pelt Wilbur F · Seattle, WABuilt 1967 · S/N 17256367 N8167QCedar Pine Construction Inc · Sturgis, SDBuilt 1975 · S/N U20603099 N8167SReid Bryce · Oklahoma City, OKBuilt 1965 · S/N 15061767 N8167TSouthern Sky LLC · Henderson, NVBuilt 1960 · S/N 17556867 N8167XAbel Jacob · Bland, MOBuilt 1961 · S/N 17248667 N81689Feisthamel Robert R · Mount Vernon, MOBuilt 1965 · S/N 18256235 N8168ADuell Levi D · Kodiak, AKBuilt 1952 · S/N 25020 N8168BJacobs Dennis A · Rochert, MNBuilt 1957 · S/N 29968 N8168USale Reported · Three Rivers, MISale reportedBuilt 1976 · S/N 15077905 N8169AVetterli Gary R · Monroe, WIBuilt 1952 · S/N 25021 N8169FRegistration Pending · Parker, KSRegistration pendingBuilt 1966 · S/N 15064269 N8169LApex Flight Training LLC · Houma, LABuilt 1967 · S/N 17256369 N8169TPerry Edward Glen Trustee · Ozark, ARBuilt 1960 · S/N 17556869 N8169UThorn Mark · Vashon, WABuilt 1964 · S/N 17252069 N8169VNelson Robert L · Fargo, NDBuilt 1968 · S/N 188-0419 N8169XHenderson George · Fresno, CABuilt 1961 · S/N 17248669 N816LRegistration Pending · Anderson, SCRegistration pendingBuilt 1968 · S/N 17256833 N816LGGray James · Jupiter, FLBuilt 1977 · S/N 17268592 N816RARochester Air Center LLC · Canandaigua, NYBuilt 1979 · S/N 17272388 N816TXDavis Derek P · Sebastian, FLBuilt 1979 · S/N R18200811 N817Naumann Scott Trustee · Arroyo Grande, CAS/N 18052844 N81708Adventist World Aviation Inc · Wilson, NCS/N 18260156 N8170BMelechin David H · Los Angeles, CAS/N 29970 N8170QMerkes Dennis R · Soldotna, AKBuilt 1952 · S/N 25412 N8170TThorn Walter W · Guilford, VTS/N 17556870 N8170UFields William B · Climax, NCBuilt 1964 · S/N 17252070 N8170XWhittington Melinda Sara Secrest · Columbus, OHBuilt 1961 · S/N 17248670 N8170ZJones Kevin C · Leander, TXBuilt 1962 · S/N 2050170 N8171BByker Robert L · Porterville, CABuilt 1957 · S/N 29971 N8171LSam Aviation LLC · Long Beach, CAS/N 17256371 N8171SLeavitt Adam · Boulder City, NVS/N 15061771 N8172AWood Thomas A · Salome, AZBuilt 1952 · S/N 25024 N8172FButler Donald S · Oak Ridge, NCBuilt 1966 · S/N 15064272 N8172UPrice Paul S · Camano Island, WABuilt 1964 · S/N 17252072 N8172VStanford Jay J · Kingsland, GAS/N A1500553 N8172XVital Twyla J · Seguin, TXBuilt 1961 · S/N 17248672 N8173BBetter Air Service LLC · Dailey, WVBuilt 1957 · S/N 29973 N8173ESky Equity LLC · Woodbury, MNBuilt 1978 · S/N 17272147 N8173FJohnson Jacob A · Shawnee, OKS/N 15064273 N8174BSmith Michael D · King George, VABuilt 1957 · S/N 29974 N8174FRangefinder Aviation LLC · Fort Collins, COS/N 15064274 N8174MFlight Time Builders Inc · Memphis, TNBuilt 1972 · S/N 17260574 N8174TMeacham Thomas · Myton, UTBuilt 1960 · S/N 17556874 N8174UJenson James H · Downers Grove, ILBuilt 1964 · S/N 17252074 N8174ZBishop Ronald E · Rolling Hills, CABuilt 1962 · S/N 2050174 N8175AFoster Mike D · Fairbanks, AKBuilt 1952 · S/N 25027 N8175BSmith Philip M · Houston, TXBuilt 1957 · S/N 29975

Back to AD 87-20-03 R2