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.

N6481BMorse Cory L · Montville, MEBuilt 1957 · S/N 29681 N6481FWood James N · Samson, ALBuilt 1966 · S/N 15063081 N6481JCape Flight Instruction Inc · Cotuit, MABuilt 1980 · S/N 17273876 N64823Training Planes LLC · Tampa, FLS/N 15281438 N6482AMoreman Wiley E · Willcox, AZBuilt 1956 · S/N 33282 N6482BMendoza Victor · Liberal, KSS/N 29682 N6482EIreland Kel · Fredericksburg, TXBuilt 1959 · S/N 46582 N6482KKimmel Timothy I · San Angelo, TXS/N 15077723 N6482MSilver Express Co DBA · Miami, FLBuilt 1980 · S/N 15284750 N6482NBoerboon Jeffrey T · Cave Creek, AZBuilt 1981 · S/N 18504311 N6482YSky West Aviation Inc Trustee · Albuquerque, NMS/N 21064400 N64831Obregon Ernest · Oakley, CABuilt 1978 · S/N 15281442 N64834Golden Mahalo LLC · Sheridan, WYBuilt 1982 · S/N 17275632 N6483AKdrcjt Aviation LLC · Orange, MAS/N 33283 N6483FRegistration Pending · Seattle, WARegistration pendingS/N 15063083 N6483GPeterson Cassandra L · Poplar Grove, ILBuilt 1970 · S/N 15071983 N6483SBlue Skies Aviation Of Wi Inc · Pulaski, WIBuilt 1967 · S/N 15067283 N64849Garcia Herbert A · Houston, TXBuilt 1981 · S/N 15285280 N6484AState Of Illinois · Springfield, ILBuilt 1979 · S/N 21063535 N6484FGrant Clinton A · Portage Des Sioux, MOS/N 15063084 N6484XMeadows Robert H · Charleston, TNFirst renewal noticeBuilt 1961 · S/N 18050984 N64859Leyva Maria · New Smyrna Beach, FLBuilt 1982 · S/N 17275636 N6485EWitte Steven E · Egan, SDBuilt 1959 · S/N 46585 N6485HBentley Dan G · Worcester, NYBuilt 1979 · S/N 15284170 N64866Universal Aviators Academy Inc · El Monte, CABuilt 1982 · S/N 17275639 N6486AErickson Jon W · Union Grove, WIBuilt 1956 · S/N 33286 N6486BDevine Aviation LLC · Atlanta, GABuilt 1956 · S/N 29686 N6486GRomeo Aviation Inc · Cumberland, WIBuilt 1970 · S/N 15071986 N6486JSpredemann Carl A · Emmett, IDBuilt 1980 · S/N 17273877 N6486LHarrison Ashley L · Danbury, CTS/N 15284414 N6486VVroom Engineering Inc · Tucson, AZBuilt 1984 · S/N T30300311 N64875Air America Flight Center LLC · Daytona Beach, FLBuilt 1982 · S/N 17275642 N6487ALucci Giancinto A · Nashville, MIS/N 33287 N6487BOneal Gary · Springdale, ARBuilt 1957 · S/N 29687 N6487DWayne County Airport Board · Monticello, KYBuilt 1979 · S/N 17272831 N6487GRedell Donald J · Lake Geneva, WIBuilt 1970 · S/N 15071987 N6487SSouth Louisiana Community College · Lafayette, LABuilt 1967 · S/N 15067287 N64882Blue Sky Flyers Inc · Greeley, COBuilt 1982 · S/N 17275643 N6488EDanielson Austin Mb · Kenai, AKBuilt 1959 · S/N 46588 N6488FLee Michael R · Kelso, WABuilt 1966 · S/N 15063088 N6488GKrog Steven L · Hartford, WIBuilt 1970 · S/N 15071988 N6488VThree Mayhoods LLC · Bonita Springs, FLS/N 172RG0725 N64891Executive Aircraft Resources LLC · Birmingham, ALBuilt 1978 · S/N 15281458 N64892Montgomery Flying Club Inc · Montgomery, ALBuilt 1982 · S/N 17275644 N64893Weitzel Laury D · Meadow, TXBuilt 1978 · S/N 15281459 N64898Fazzini Pamela A · Sedona, AZBuilt 1978 · S/N 15281464 N6489EDupuis Normand G · Berlin, NHBuilt 1959 · S/N 46589 N6489HMoon Flight Aviation LLC · Barto, PABuilt 1981 · S/N 18267891 N6489MSouthern Illinois University Board Of Trustees DBA · Murphysboro, ILBuilt 1980 · S/N 15284753 N6489WReed Michael · Temple, TXBuilt 1981 · S/N P21000785

Back to AD 87-20-03 R2