Registered aircraft · 54,017

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.

N5498TSale Reported · Lewes, DESale reportedS/N 17251398 N5499CJohnson Linzy A · Lake Stevens, WABuilt 1950 · S/N 19533 N5499QCronce Charles Scott · Pacifica, CABuilt 1981 · S/N 15285114 N5499RHooper Gordon T · Hiawatha, KSBuilt 1965 · S/N 17253069 N549PUBerkey Aviation LLC · Lafayette, INBuilt 1976 · S/N 15078918 N54AFSpohnholz Randy K · Anchorage, AKBuilt 1954 · S/N 30943 N54AKGreat Planes Reproductive Centers Pa · Circle Pines, MNBuilt 1981 · S/N 21064473 N54BKDanny J Daigle LLC · Greenville, MEBuilt 1981 · S/N 18268073 N54CCScythe & Spade Co · Grand View, IDBuilt 1979 · S/N P21000360 N54DZMcdonald Donald F · Greer, SCBuilt 1983 · S/N 21064820 N54EPortland Community College · Portland, ORBuilt 1973 · S/N P3370156 N54EJHigh Plains Aviation LLC · Caro, MIS/N 18504330 N54GCWilson Karlton M · Craigmont, IDBuilt 1959 · S/N 46454 N54GVAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1978 · S/N 20700447 N54HHGrillot Michelle L · Kannapolis, NCBuilt 1961 · S/N 15059240 N54JMAviation Institute Of Maintenance · Virginia Beach, VABuilt 1968 · S/N 17257026 N54JRBlock John R · Pittsburgh, PABuilt 1977 · S/N P3370278 N54KDSawtooth Flying Service Inc · Mccall, IDBuilt 1981 · S/N U20606181 N54KHHertenstein Kevin Wayne · Lutz, FLBuilt 1979 · S/N 17272726 N54LLRyan Good Aviation LLC · Sioux Falls, SDBuilt 1968 · S/N 185-1463 N54MEZhang Ning · Edmond, OKS/N P20600641 N54MMGwinn Roger A · Maple, NCBuilt 1979 · S/N 21063756 N54PRReimer Lynn C · Sioux Falls, SDBuilt 1972 · S/N 17260943 N54PSAustin Bill DBA · Sparta, TNBuilt 1980 · S/N P21000492 N54PWScheffers Lee · Riverside, CABuilt 1979 · S/N 18266804 N54RAerometrix LLC · Lawrence, KSBuilt 1981 · S/N 21064514 N54RAAshlock Mark L · Loomis, CABuilt 1980 · S/N R18201684 N54RWBaylis Thomas B · Hattiesburg, MSBuilt 1966 · S/N 18256924 N54SDJerry W And Barbara J Smith Family Land Lllp · Blanca, COBuilt 1954 · S/N 31162 N54TVAllen And Lambert Inc · Bolingbroke, GABuilt 1975 · S/N 18264264 N54VAFisheer Eric E · Memphis, TNBuilt 1968 · S/N 17257295 N54WCFlorian Nathan A · Homosassa, FLBuilt 1961 · S/N 18253465 N54WDHat Creek Aviation LLC · Hamilton, MTBuilt 1981 · S/N R18201709 N5500BKay James L · Irvine, CABuilt 1956 · S/N 33500 N5500GCummings Terence J · Morgan Hill, CABuilt 1971 · S/N 17260300 N5500TOhair Ronald L · Pasco, WABuilt 1964 · S/N 17251400 N5501BSeymour George N · Shelby, MTBuilt 1956 · S/N 33501 N5502GKeeven Diana F · New Smyrna Beach, FLBuilt 1969 · S/N 15071002 N5502TMartin William G · Mc Clellandtown, PABuilt 1964 · S/N 17251402 N5503TAivia Aviation LLC · Estes Park, COBuilt 1964 · S/N 17251403 N5504CLevsen Daniel C · Clarence, IABuilt 1950 · S/N 19538 N5504RAerocareers Nfp · Columbia, ILBuilt 1965 · S/N 17253075 N5504TLam Pak To · El Monte, CABuilt 1964 · S/N 17251404 N5505GOsterhaus Nolan · Blair, NEBuilt 1969 · S/N 15071005 N5505RMerritt Island Flying Club Inc · Merritt Island, FLBuilt 1965 · S/N 17253077 N5505XDuff Trent H · Warrenton, MOBuilt 1964 · S/N 17251188 N5506GSanchez Carlos D · Ashburn, VABuilt 1969 · S/N 15071006 N5506RAnderson Interests LLC · East Bernard, TXBuilt 1965 · S/N 17253078 N5506TMorgan Ronnie · Keller, TXBuilt 1964 · S/N 17251406 N5507CAnderson Michael J · Carmichael, CABuilt 1950 · S/N 19541

Back to AD 87-20-03 R2