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.

N725ECDraco Flight School Inc · Chino, CABuilt 1972 · S/N 17260842 N725LCReeves Jerry H · Whitesburg, GABuilt 1964 · S/N 17251919 N725RBBatesole William D Trustee · Walpole, NHBuilt 1968 · S/N 15068309 N725RJWilliams Sol F · Jacksonville, FLBuilt 1971 · S/N 17260254 N725VPTeam Negrich LLC · Osteen, FLBuilt 1971 · S/N U20601664 N725ZNLaramie Flying Club Inc · Laramie, WYBuilt 1979 · S/N 17272734 N7260XCoutu Justin · Whitewater, COBuilt 1961 · S/N 15059360 N7261ACassity Michael D · Springfield, MOBuilt 1956 · S/N 29361 N7261GKindblade Aeronautics LLC · Casper, WYBuilt 1970 · S/N 17258961 N7261QSchilling Aviation Services LLC · Salina, KSS/N 17260561 N7262EStrough Jacob L · Twin Falls, IDBuilt 1959 · S/N 52262 N7262QFlikins Barbara L · Fillmore, CABuilt 1972 · S/N 17260562 N7263AHillside Farms · Elaine, ARBuilt 1956 · S/N 29363 N7263GHardy Chad A · Rush City, MNBuilt 1970 · S/N 17258963 N7263MGolan Shachar Yaacov · Farmington Hills, MIBuilt 1958 · S/N 55563 N7263QWyatt Barbara Louise · Cheyenne, WYBuilt 1972 · S/N 17260563 N7263TScheler Thomas · Independence, ORS/N 46863 N7264ABridge Creek Logging Inc · Mount Vernon, ORBuilt 1956 · S/N 29364 N7264NSelect Equipment Inc · Kokomo, INBuilt 1974 · S/N 18263053 N7264QAdams Rick B · Ashford, WABuilt 1972 · S/N 17260564 N7265NSkylane Bicentennial LLC · Waynesboro, VABuilt 1974 · S/N 18263054 N7265SRiver City Flying Club Inc · Sacramento, CABuilt 1976 · S/N 18265087 N7265TKor Aviation LLC · Piedmont, SDBuilt 1959 · S/N 46865 N7266ABrooks David A · East Dorset, VTBuilt 1956 · S/N 29366 N7266DMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17272912 N7266QLima-001 LLC · Muscatine, IABuilt 1972 · S/N 17260566 N7266SRush William A Trustee · Boulder Creek, CAFirst renewal noticeBuilt 1976 · S/N 18265088 N7266TNobles Gary Allen · Winnsboro, LAS/N 46866 N7267EHigh Range Aviation Inc · Gooding, IDBuilt 1959 · S/N 52267 N7267GWells Jack D · Newtown, MOBuilt 1970 · S/N 17258967 N7267MLeasa Marc · Fond Du Lac, WIBuilt 1958 · S/N 55567 N7267NSwalling John C · Anchorage, AKBuilt 1976 · S/N U20603594 N7267XJudge Eli A · Whitefish, MTBuilt 1961 · S/N 15059367 N7268EBoyer Steven L · Wooster, OHBuilt 1959 · S/N 52268 N7268TParker Harold E · Cabot, ARFirst renewal noticeBuilt 1959 · S/N 46868 N7269EFerguson Douglas M · Mount Vernon, ORBuilt 1959 · S/N 52269 N7269GBranson Barry R · Shasta Lake, CABuilt 1970 · S/N 17258969 N7269NAk Air Leasing LLC · Homer, AKBuilt 1976 · S/N U20603595 N7269QBaker Mark · White Bear Lake, MNBuilt 1972 · S/N 17260569 N726AJStarr Alan D · Senoia, GABuilt 1969 · S/N 17701378 N726AMRegistered aircraftBuilt 1953 · S/N 26009 N726ASA2g International LLC · San Juan Capo, CABuilt 1975 · S/N 33701661 N726HSSpmhrt 206 LLC · East Bernard, TXS/N U20606947 N726JHClearview Flying Club Inc · Westminster, MDBuilt 1977 · S/N 17269494 N726MBBurgos Orlando · Venice, FLBuilt 1982 · S/N 17275766 N726MMRiverside Flight Academy LLC · Riverside, CABuilt 1979 · S/N 17272970 N727United States Department Of Interior · Boise, IDBuilt 1982 · S/N 18504371 N7270GBruneau Paul G Jr · Madison, MEBuilt 1970 · S/N 17258970 N7270NRivera Daniel A · San Marcos, TXBuilt 1974 · S/N 18263059 N7270TBudenbender Philip W · Weatherford, TXBuilt 1959 · S/N 46870

Back to AD 87-20-03 R2