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.

N7480APacific Ag Services · Firebaugh, CABuilt 1957 · S/N 29580 N7480GPage Ralph W · Jennings, LABuilt 1970 · S/N 17259180 N7480QDecatur Aero Club Inc · Decatur, ILBuilt 1972 · S/N 18261120 N7480THalley Dan R · Avery, TXBuilt 1959 · S/N 47080 N7480XFoster Ricardo E · Lutz, FLBuilt 1960 · S/N 17247980 N7481AGrocholl Mark · Rockton, ILBuilt 1956 · S/N 29581 N7481GUncapher Elmer D · Mendon, OHS/N 17259181 N7481TFairon Daniel · Fox Island, WABuilt 1959 · S/N 47081 N7482MSchwab Mark C · Kimball, MIBuilt 1959 · S/N 55782 N7482XWilliams John R · Maquoketa, IABuilt 1960 · S/N 17247982 N7483EMerriman David A · Rocklin, CABuilt 1960 · S/N 57183 N7483QDawson Stewart J · Celina, TXBuilt 1978 · S/N 18503606 N7483XDoerr David B · Verdon, NEBuilt 1960 · S/N 17247983 N7484MMesiar David C · Anchorage, AKBuilt 1959 · S/N 55784 N7484QPlanebroker.Com LLC · Miramar Beach, FLBuilt 1972 · S/N 18261124 N7484XHoulton Timbre R · Fairbanks, AKBuilt 1960 · S/N 17247984 N7485APrecup Michael P Sr Trustee · Perrysville, OHBuilt 1956 · S/N 29585 N7485CYanover Joseph J · Traverse City, MIBuilt 1974 · S/N 18502373 N7485EJacques Steve C · Centennial, COBuilt 1960 · S/N 57185 N7485GIndependent Aviation Services LLC · Sachse, TXBuilt 1970 · S/N 17259185 N7485MLyons Adrian K · Torrance, CABuilt 1959 · S/N 55785 N7485QEvans Charles H Trustee · Hooksett, NHBuilt 1973 · S/N U20602220 N7485XEngland Robert C · Zanesville, OHBuilt 1960 · S/N 17247985 N7486MYaeger John F · Au Gres, MIBuilt 1959 · S/N 55786 N7486SGarage Doors Of Greenville LLC · Greenville, MSBuilt 1969 · S/N 15070358 N7486TRhodes Vergil H Jr · Bartlesville, OKBuilt 1959 · S/N 47086 N7487ANelson Rodney G · Amenia, NDBuilt 1957 · S/N 29587 N7487GRich Aviation Services LLC · Fort Worth, TXBuilt 1970 · S/N 17259187 N7487MMaple Lake Flyers Corp · Maple Lake, MNBuilt 1959 · S/N 55787 N7487Q206 LLC · Anchorage, AKBuilt 1973 · S/N U20602221 N74887Mroz Kaitlin J · Haslet, TXBuilt 1953 · S/N 25853 N7488MFegert Jeff · Las Vegas, NVBuilt 1959 · S/N 55788 N7489AAllianna LLC · Fayetteville, ARBuilt 1956 · S/N 29589 N7489GCloud Fleet Aviation LLC · Fort Lauderdale, FLBuilt 1970 · S/N 17259189 N7489MMerinar John R Jr · Bridgeport, WVBuilt 1959 · S/N 55789 N7489QLlano Masonry LLC · Lubbock, TXBuilt 1972 · S/N 18261129 N748KPKalinin Partners LLC · Juneau, AKBuilt 1976 · S/N U20603279 N748WPParker Charles W III · Anchorage, AKBuilt 1967 · S/N 185-1207 N748XMorgan Bryon E · Eugene, ORS/N 3370029 N749United States Department Of Interior · Boise, IDBuilt 1982 · S/N 18504354 N7490XDawson Ejay J · Eveleth, MNBuilt 1960 · S/N 17247990 N7491AMckee Paul R · Astoria, ORBuilt 1957 · S/N 29591 N7491EBenscoter Richard S · Nordman, IDBuilt 1960 · S/N 57191 N7491GAccess Air Service Inc · Mercedita, PRBuilt 1970 · S/N 17259191 N7492TSale Reported · Newport, ORSale reportedS/N 47092 N7493GHaugo Robert P · Scobey, MTBuilt 1970 · S/N 17259193 N7493TLee Cody C · Denton, MTS/N 47093 N7495MPlumley David E · Waxhaw, NCBuilt 1959 · S/N 55795 N7495XIsch Philip D · Geneva, INBuilt 1960 · S/N 17247995 N7496AMcreynolds Sean D · Visalia, CABuilt 1956 · S/N 29596

Back to AD 87-20-03 R2