Registered aircraft · 54,019

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.

N1489DAce Hole Flying Club LLC · Spokane, WABuilt 1951 · S/N 20091 N1489EWings Over Water Inc · Minneapolis, MNBuilt 1978 · S/N 17271019 N1489FHoover Andrew V · Jenison, MIBuilt 1966 · S/N 17254984 N1489MBrinker Corp Inc · Glen Elder, KSBuilt 1975 · S/N 18264350 N1489SBender Roger J · Overgaard, AZBuilt 1976 · S/N 18265036 N1489UAustin Aeroflight Inc · Austin, MNBuilt 1976 · S/N 17267156 N148ELFrazier James M III · Saint Marys, KSBuilt 1975 · S/N 15077412 N148GMorrill William I · Kerrville, TXBuilt 1979 · S/N 18267097 N148JBBell Jason W · Flower Mound, TXBuilt 1979 · S/N 18266827 N148TXRegistration Pending · Austin, TXRegistration pendingBuilt 1979 · S/N 18267500 N1490DCole Daniel G · Pittsburgh, PAS/N 20092 N1490EFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1978 · S/N 17271020 N1490SEfna LLC · Wichita, KSBuilt 1976 · S/N 18265037 N1491UGardner Christopher · Farmers Branch, TXBuilt 1976 · S/N 17267158 N1491YBullard Thomas Eugene Trustee · Midlothian, TXBuilt 1962 · S/N 17249191 N1492DLevin Amanda L Trustee · Prairie Du Sac, WIBuilt 1951 · S/N 20094 N1492QDavison James D · Richmond, MAS/N 15072792 N1492SBurr John R · Salem, VABuilt 1976 · S/N 18265039 N1493DJobe Waylen Mark · Eugene, MOBuilt 1951 · S/N 20095 N1493ESherman Aviation LLC · Fairfield, NJBuilt 1978 · S/N 17271022 N1493FAdventist World · Wilson, NCBuilt 1966 · S/N 17254988 N1493MOverly Terrence L · Tok, AKS/N U20601493 N1493VMy Flight LLC · Cypress, TXBuilt 1974 · S/N 17263623 N1494CFour C'S Equipment Leasing LLC · Fresno, CABuilt 1978 · S/N 21063065 N1494DFuller Scott M · Edinburg, TXBuilt 1951 · S/N 20096 N1494FThompson Kevin L · Jefferson, TXBuilt 1966 · S/N 17254989 N1494QSauter Allen · Bismarck, NDBuilt 1971 · S/N 15072794 N1494S1494 Sierra Inc · Waynesville, OHBuilt 1976 · S/N 18265041 N1494VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263624 N1495CGulf Coast Helicopters Inc · Pearland, TXBuilt 1977 · S/N 17702737 N1495UFairflight LLC · San Diego, CABuilt 1976 · S/N 17267162 N1496FSmith James F · Red Springs, NCBuilt 1966 · S/N 17254991 N1496MMustang Sally Aviation LLC · Camden, SCS/N 18264352 N1496QDonat Brandon L · Glendale, AZBuilt 1971 · S/N 15072796 N1496YHoward Paul D · Gordon, TXS/N 17249196 N1497FBlunk Rodney · Bettendorf, IABuilt 1966 · S/N 17254992 N1497YHall Robert D · Prince-Frederick, MDBuilt 1962 · S/N 17249197 N1498CBrutger Wayne A · Saddlebrooke, AZBuilt 1978 · S/N 17702739 N1498MSoaring Utah Inc · Sandy, UTBuilt 1975 · S/N 18264353 N1498SNull Perry D · Gallup, NMBuilt 1976 · S/N 18265045 N1498VMoore James E · East Falmouth, MABuilt 1974 · S/N 17263628 N1499CGalbrecht Daniel S · Arbor Vitae, WIBuilt 1978 · S/N 17702740 N1499SSkylane Pictures LLC · Los Angeles, CABuilt 1976 · S/N 18265046 N1499YHockenberry Randall L · Cape Coral, FLBuilt 1962 · S/N 17249199 N149JCCorrea Javier Rafael · Caguas, PRS/N 17276119 N149TBonilla Jose · Pembroke Pines, FLBuilt 1981 · S/N 18267896 N14AUBazzo Richard J · Broadview Heights, OHBuilt 1967 · S/N 15064814 N14AZD & L Aircraft Leasing LLC · Ormond Beach, FLBuilt 1975 · S/N 17263495 N14BABurris & Macomber P L L C Trustee · Tucson, AZS/N 18261211 N14BLEagle Equity Inc · Valparaiso, INBuilt 1968 · S/N 17257735

Back to AD 87-20-03 R2