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.

N7024QWells Nathan S · Scotia, NEBuilt 1971 · S/N 17260324 N7024TCorrigan Joseph M · San Marcos, CABuilt 1959 · S/N 46624 N7024XGresli Mark D · Arlington, WABuilt 1961 · S/N 15059124 N70253Claus Jay G · Palmer, AKBuilt 1972 · S/N 18502082 N70256Winn Edwin F · Louisville, KYBuilt 1976 · S/N 17267199 N7025MHelms Everett L · Creighton, MOBuilt 1958 · S/N 55325 N7026MLoerzel Loren · Blair, NEBuilt 1958 · S/N 55326 N70278Cooper Jeffrey A · Anchorage, AKBuilt 1972 · S/N 18502090 N7027QAero B Flying Service · Richards, MOBuilt 1971 · S/N 17260327 N7027SRed Cessna Aviation LLC · West Valley City, UTS/N 15067727 N7027XWright Michael J Trustee · Santa Ana, CABuilt 1960 · S/N 15059127 N70288Dakota Aircare Inc · Wagner, SDBuilt 1974 · S/N 18801879T N7028AMazzarese Nicholas · Cedar Hills, UTBuilt 1956 · S/N 29128 N7028EHeidebrink Ronald · Loris, SCS/N 56528 N7028GKathol Donavin J · Hartington, NEBuilt 1969 · S/N 17258728 N7028QBurns Michael S · Coplay, PABuilt 1971 · S/N 17260328 N7028SSkylane LLC · Salt Lake City, UTS/N 18265049 N7028TFoster Chase · Mountain View, MOS/N 46628 N7029ELewis Stephen · Lebanon, ORS/N 56529 N7029SWright Flyers LLC · Fayetteville, GABuilt 1967 · S/N 15067729 N7029XMuroc Joint Unified School District · North Edwards, CABuilt 1960 · S/N 15059129 N702BDaly Moses M · Underhill, VTS/N U206-1279 N702DEKelly William G · Cape May Ct House, NJFirst renewal noticeS/N 17276522 N702DZSkydive Fargo Inc · West Fargo, NDBuilt 1966 · S/N P206-0152 N702GTsiouklas Aviation Inc · Dunedin, FLBuilt 1968 · S/N 17256919 N702HPJoplin Flyers Inc · Joplin, MOFirst renewal noticeBuilt 1982 · S/N 18268167 N702SDVaughn Gregory T · Santa Fe, TXS/N R18200293 N702TCSykes Gregory P · Arlington, WAFirst renewal noticeBuilt 1976 · S/N 21061672 N702VPCaribbean Air Partners LLC · Winter Garden, FLBuilt 1964 · S/N 17251373 N7030AStuckle Eugene A · Davenport, WABuilt 1956 · S/N 29130 N7030FPaul William · Windfall, INBuilt 1966 · S/N 15063630 N7030SAcoba Dylan Anthony · Orangevale, CABuilt 1967 · S/N 15067730 N7031MClarity Aviation LLC · Anchorage, AKBuilt 1958 · S/N 55331 N7031SBurns Randall A · Rogers, ARBuilt 1967 · S/N 15067731 N7031XKeller Jeffery W · Longview, TXBuilt 1961 · S/N 15059131 N70323Sky Equity LLC · Woodbury, MNBuilt 1976 · S/N 17267200 N70326Triple E Farms LLC · Peculiar, MOBuilt 1974 · S/N 18801887T N7032ARobinson Michael D · Folkston, GABuilt 1956 · S/N 29132 N7032QRegistration Pending · Oakwood, OHRegistration pendingBuilt 1976 · S/N U20603067 N7032STamayo Ernest R · Dripping Springs, TXS/N 15067732 N7032XSmith David P · Pacific Palisades, CABuilt 1960 · S/N 15059132 N70333Northland Aircraft Sales LLC · Fairbanks, AKBuilt 1972 · S/N 18502115 N7033AWalter Aviation LLC · Bradenton, FLS/N 29133 N7033TTimm Alan W · Hettinger, NDS/N 46633 N70340Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267203 N70341Michels LLC · Wasilla, AKBuilt 1972 · S/N 18502119 N7034GFat Tyre Flyers LLC · Moses Lake, WABuilt 1969 · S/N 17258734 N7034QTesch David P · Pardeeville, WIBuilt 1971 · S/N 17260334 N70350Bigwings Ag Inc · Delavan, MNS/N 18801895T N70358Mcgugin Donald W · Anacortes, WAS/N 18502129

Back to AD 87-20-03 R2