Registered aircraft · 72,010

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-10-06-R1') 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-10-06-R1') 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-10-06-R1')
    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-10-06-R1')
  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-10-06-R1')
  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-10-06-R1')
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.

N4056WHighwing Flyers Inc · Cape May Ch, NJBuilt 1966 · S/N 32-40081 N4056XHolliday Ralph C III · Coppell, TXBuilt 1970 · S/N 5156 N4056ZG & L Airborne Inc · Wilmington, DEBuilt 1963 · S/N 18-8064 N40571Bwh Leasing LLC · Lewes, DEBuilt 1974 · S/N 27-7405313 N40575Evans Samuel F · Iuka, MSBuilt 1976 · S/N 18-7709018 N40578Dna Flight Ops LLC · Edgewater, FLBuilt 1974 · S/N 27-7405322 N40579Burwell Jeffery S · Wasilla, AKBuilt 1976 · S/N 18-7509129 N4057NMominee Jules T · Evansville, INBuilt 1968 · S/N 680027 N4057RCurrier Dustan · Fairbanks, AKBuilt 1967 · S/N 32-40361 N4057W57whiskey LLC · Rowlett, TXBuilt 1966 · S/N 32-40083 N4057ZBruegger Shannon B · Lance Creek, WYBuilt 1963 · S/N 18-8066 N40581Chagres Aero LLC · Albuquerque, NMBuilt 1974 · S/N 27-7405325 N40588Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 1974 · S/N 27-7405332 N4058NHancock Randall G · Evanston, WYBuilt 1968 · S/N 680168 N4058RSanders Christopher A · Escondido, CABuilt 1967 · S/N 32-40363 N4058WBrandon Sidney J III · Dundas, VABuilt 1966 · S/N 32-40085 N4058XLeading Edge Aviation Foundation Inc · Mountain Home, ARFirst renewal noticeBuilt 1970 · S/N 5158 N40592Rml Aircraft Inc · Staunton, VABuilt 1974 · S/N 27-7405337 N40599Tcb Aviation Inc · Knoxville, TNBuilt 1974 · S/N 27-7405345 N405AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843738 N405ASJagadeesh Akhil V · Chicago, ILBuilt 1972 · S/N 28-7205263 N405CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881110 N405CGPinheiro Rodrigo Postal · Albuquerque, NMBuilt 1994 · S/N 27-0179 N405CMHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2000 · S/N 3096 N405DSDelaware State University · Dover, DEBuilt 1976 · S/N 28-7715243 N405DTSkiles Carl A · Leander, TXS/N 17702389 N405FDQualitair LLC Trustee · MichelstadtBuilt 1990 · S/N 770 N405FLRiggin Flight Service Inc · Madison, SDBuilt 1971 · S/N 28-7125181 N405JHTss Flying Club Inc · Bethesda, MDBuilt 1981 · S/N R18201790 N405MAHigh Ways LLC · Colorado Springs, COBuilt 2005 · S/N 40.546 N405MHCall One Inc · Clarinda, IABuilt 2024 · S/N 8-10830 N405NDSmith Michael Christopher · Concord, NCBuilt 2004 · S/N 2844113 N405RRBjp Aviation LLC · Seattle, WABuilt 2005 · S/N 10700 N405RVNorberg Robert J · Las Vegas, NVS/N 005 N405SGriffing Flying Service Inc · Port Clinton, OHBuilt 1986 · S/N 2890015 N405SBSky Bright Inc · Gilford, NHBuilt 1978 · S/N 28-7916139 N405SPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1999 · S/N 172S8298 N405THNewgren Steven A · Kasilof, AKBuilt 1975 · S/N 18-7509005 N405TSRichard N Appling · Ellensburg, WABuilt 1963 · S/N 30-159 N405WBNew England Airlines Inc · Westerly, RIBuilt 1975 · S/N 32-7640043 N405WFVan Bortel Aircraft Inc · Arlington, TXBuilt 1999 · S/N 18280563 N405XStover Lance E · Eden Prairie, MNBuilt 1976 · S/N 7038C N4060BSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 75-31110 N4060FJones Brent M · Las Vegas, NVS/N 28-7790003 N4060LBentley Aviation Services LLC · Lewes, DEBuilt 1966 · S/N 27-3324 N4060XTroyer Randy · Goshen, INBuilt 1970 · S/N 5160 N40614Marcotte Stuart E · Soldotna, AKBuilt 1972 · S/N 2138C N4061MKrupinski Floyd M · Chugiak, AKBuilt 1947 · S/N 12-2950 N4061NChristensen Kier · Scottsdale, AZBuilt 1968 · S/N 680028 N4061RHorse Saddle Shop Inc · Bremen, INBuilt 1967 · S/N 32-40369

Back to AD 87-10-06 R1