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.

N6857DDynamic Aerospace Inc · Framingham, MABuilt 1951 · S/N 7848 N6857GDuran Alexander · Holbrook, NYBuilt 1970 · S/N 15072357 N6857HNew Mexico Flying Eagle Inc · Tucson, AZBuilt 1975 · S/N 17265611 N6857MRegistration Pending · Lenoir City, TNRegistration pendingBuilt 1975 · S/N 18263862 N6857RRegistered aircraftBuilt 1967 · S/N T210-0257 N6858ACorrigan Flying Club · Manitowoc, WIBuilt 1956 · S/N 28958 N6858EMalara Steven · Frankfort, NYBuilt 1984 · S/N 18268378 N6858HPrairie Skies Aviation LLC · Hutchinson, KSBuilt 1975 · S/N 17265612 N6858XHoang Andrew Q · Seal Beach, CABuilt 1960 · S/N 17247758 N6859AClark Brenton J · Fairfield, IAFirst renewal noticeS/N 28959 N6859EAndersen Henrik T · Golden, COBuilt 1959 · S/N 56359 N6859HRoeper Gary Lee · Linden, MIS/N 17265613 N6859MRegistration Pending · Woodruff, SCRegistration pendingBuilt 1975 · S/N 18263863 N6859RRomeo Airmotive LLC · Stockton, CABuilt 1967 · S/N T210-0259 N6859XWilkerson Bradley W · Caldwell, IDBuilt 1960 · S/N 17247759 N685GTEatmb Air Inc Trustee · Wilmington, DEBuilt 1979 · S/N 21063361 N685JMBallard Aviation · Waynesville, MOBuilt 1974 · S/N 18801992 N685LACorr Joshua · Santa Paula, CABuilt 1965 · S/N 185-0876 N685RADenkat Plane Shadow LLC · Buckeye, AZBuilt 1968 · S/N 15068701 N685SSecond Wind Aviation Corp · Friday Harbor, WABuilt 1970 · S/N 20700184 N685VAlpha Golf Flyers Inc · Wilmington, DEBuilt 1976 · S/N P3370265 N68608Oxford Aircraft Leasing LLC · Oxford, NCBuilt 1978 · S/N 15282317 N6860HUniversity Of Michigan Flyers · Ann Arbor, MIBuilt 1975 · S/N 17265614 N6861EBeckerman George F · Mount Carmel, ILBuilt 1959 · S/N 56361 N6861HViking Systems Inc · Naples, FLS/N 17265615 N6861MEwing Aviation LLC · Ellisville, MSBuilt 1975 · S/N 18263865 N6861RJohnson Bradley Michael · Belgrade, MTBuilt 1967 · S/N T210-0261 N6862EBostik Industries LLC · Green Cove Springs, FLS/N 56362 N6862FGradel Thomas A Jr · Irmo, SCBuilt 1966 · S/N 15063462 N6862HStrickland J A · Fairbanks, AKBuilt 1975 · S/N 17265616 N6862MCreacy Jason Thomas · Gatesville, TXBuilt 1975 · S/N 18263866 N68639Bathalter Michelle N · Las Vegas, NVBuilt 1960 · S/N 18253073 N6863AZinter Dean K · Tigard, ORBuilt 1956 · S/N 28963 N6863MRvandco LLC · Missoula, MTBuilt 1975 · S/N 18263867 N6863TBering Capital LLC · Anchorage, AKBuilt 1973 · S/N 17262470 N6864ABrusik John A Jr DBA · New Port Richey, FLS/N 28964 N6864HMay Jeffrey N · Ocala, FLBuilt 1975 · S/N 17265618 N6864MKnott Dustin Shane · Brentwood, CABuilt 1975 · S/N 18263868 N6864RRankin Bryan · Cloverdale, CABuilt 1967 · S/N T210-0264 N6865ESustek Jerry · Seattle, WABuilt 1959 · S/N 56365 N6865FGeissler Robert William Jr · Baltimore, MDBuilt 1966 · S/N 15063465 N6865XGessley Lester Jack Jr · Port Saint Lucie, FLBuilt 1960 · S/N 17247765 N68662Edwards Joseph C Trustee · Austin, ARBuilt 1958 · S/N 55543 N6866AJlk Inc · Malvern, ARBuilt 1956 · S/N 28966 N6866EStuart Bradley J · Hillsboro, NDBuilt 1959 · S/N 56366 N6866FLand Ross A · Cedar Rapids, IAS/N 15063466 N6866HParrish Michael C Trustee · Lakeland, FLBuilt 1975 · S/N 17265619 N6866ROrnes W Harold · Aiken, SCBuilt 1967 · S/N T210-0266 N6867AHeffron Jacob L · Little Falls, MNS/N 28967 N68688Registered aircraftS/N 15282322

Back to AD 87-20-03 R2