Registered aircraft · 54,019

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.

N2706VBeuschel Timothy W · Mount Pleasant, WIBuilt 1975 · S/N 177RG0666 N2707CPlane Fun Inc Tr Trustee · Snellville, GABuilt 1955 · S/N 26251 N2707FMontgomery Robert · Casper, WYS/N 18256807 N2707GFluckey Gary T · Homer, AKBuilt 1959 · S/N 52007 N2707UHills Holding · Newark, DEBuilt 1963 · S/N 17250307 N2708LRafter Jm Enterprises LLC · Swink, OKBuilt 1967 · S/N 17255908 N2708QElkhorn Aviation Inc DBA · Baker City, ORBuilt 1967 · S/N 18257908 N2709CKyzer David D · Anchorage, AKS/N 26253 N2709FArmentrout Billy W · Thomasville, NCBuilt 1965 · S/N 18256809 N2709LGuideair LLC · Eden Prairie, MNBuilt 1967 · S/N 17255909 N2709XCmvii LLC · Chugiak, AKBuilt 1965 · S/N 18051509 N270ATsg Associates LLC · Stanley, NCBuilt 1978 · S/N R18200067 N270AMCode 1 Flight Training LLC · Wills Point, TXBuilt 1973 · S/N 17262722 N270KCLeyva Kevin S · Wilbur, WABuilt 1955 · S/N 31505 N270MRFurtado William J III DBA · Fremont, CABuilt 1976 · S/N 21061660 N270SVJones Joseph D · Broken Arrow, OKBuilt 1978 · S/N 15282329 N2710CFrazier James C · Hinesburg, VTBuilt 1954 · S/N 26254 N2710UCape Aerial Tours DBA · Chatham, MABuilt 1963 · S/N 17250310 N2710XReinhart Richard A · Cook, MNBuilt 1965 · S/N 18051510 N2711CHolly Shawn L · Soldotna, AKBuilt 1954 · S/N 26255 N2711DSpinner James C · Belleville, ILBuilt 1952 · S/N 25253 N2711GAlexander Marshall J · Klamath Falls, ORBuilt 1959 · S/N 52011 N2712CDunn Richard B · Otis, MEBuilt 1954 · S/N 26256 N2712DBlackwood R John Trustee · Salinas, CABuilt 1952 · S/N 25254 N2712QGrotbeck Carter L · Albuquerque, NMBuilt 1967 · S/N 18257912 N2712SKelly Matthew Raymond · New Florence, MOBuilt 1967 · S/N 15066612 N2713DBlack Mountain Flying Service Ltd · Boulder City, NVBuilt 1952 · S/N 25255 N2713GPalmer Carroll W · Harper, ORBuilt 1959 · S/N 52013 N2713LFlemmer Richard W · Park City, MTBuilt 1967 · S/N 17255913 N2713QJeff Jones Aircraft Company LLC · Quincy, WABuilt 1967 · S/N 18257913 N2713UAeronetica LLC · Tulsa, OKS/N 17250313 N2714DDeane Gregory H · Anacortes, WABuilt 1953 · S/N 25256 N2714FDdh LLC · Goddard, KSBuilt 1965 · S/N 18256814 N2714GRegistered aircraftBuilt 1959 · S/N 52014 N2714JRegistered aircraftBuilt 1974 · S/N A1500566 N2715CHead Nyle C · Sisters, ORS/N 26259 N2715DEducation Connection LLC · Port Saint Lucie, FLBuilt 1952 · S/N 25257 N2715FLow Wings Aviation LLC · Gassville, ARBuilt 1965 · S/N 18256815 N2715LGoebel Christian E · Luray, VABuilt 1967 · S/N 17255915 N2715UBelle Fourche Flight Center LLC · Belle Fourche, SDBuilt 1963 · S/N 17250315 N2716DDammann Willa B · Murrieta, CABuilt 1952 · S/N 25258 N2716SWright Herbert L · Vickery, OHBuilt 1967 · S/N 15066616 N2716XShaw Brandon L · Juneau, AKBuilt 1965 · S/N 18051516 N2717CGibboney Scott H · Temecula, CABuilt 1954 · S/N 26261 N2717DGrimsley Steve K · Underhill, VTBuilt 1953 · S/N 25259 N2717GKlotz Terrance M · Sparks, NVBuilt 1959 · S/N 52017 N2717SMartin Tyler · Pompano Beach, FLBuilt 1967 · S/N 15066617 N2717URasmussen Raleigh C · Seattle, WABuilt 1963 · S/N 17250317 N2718DCongdons Aviation Service · Anchorage, AKBuilt 1952 · S/N 25260 N2718FJackalope Flyers LLC · Whitefish, MTBuilt 1965 · S/N 18256818

Back to AD 87-20-03 R2