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.

N176LGTita Enterprises LLC · Apex, NCS/N 172RG0074 N176LLClear Above LLC · Haymarket, VABuilt 1975 · S/N 21061135 N176TCRedtail Cirrus LLC · Boise, IDBuilt 1979 · S/N 18503814 N176YCessna U206f Aviation LLC · Boise, IDS/N U206-03383 N1770RRegistered aircraftBuilt 1974 · S/N 18502490 N1770XPark Avenue Group Inc · Stuart, FLBuilt 1975 · S/N 21060791 N1771MGaley Matthew Blake · Greenwood, MSBuilt 1975 · S/N 18264433 N1772FTia Aviation LLC · Hot Springs, ARBuilt 1966 · S/N 17255167 N1773BBaney Robert P · Philipsburg, PABuilt 1977 · S/N 17702730 N1773DReeves Stephen E · Palm Harbor, FLBuilt 1951 · S/N 20216 N1773FRegistration Pending · Jasper, ALRegistration pendingBuilt 1966 · S/N 17255168 N1773RAsher Robert P · Oregon City, ORBuilt 1978 · S/N R18200554 N1773ZMcclay David H · Lagrande, ORBuilt 1963 · S/N 336-0073 N1774CStol LLC · Fort Wayne, INBuilt 1953 · S/N 30474 N1774DDj Brandt LLC · Cedar City, UTS/N 17702028 N1774FBarnstormers Aero Services Inc · Lompoc, CABuilt 1966 · S/N 17255169 N1774HPeacock Bruce M · Mendon, VTBuilt 1980 · S/N 18267507 N1774VAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263747 N1775QBrooks Timothy J · Oshkosh, WIS/N 15073075 N1775RAnderson Lenny R · King Salmon, AKBuilt 1974 · S/N 18502494 N1776DRobbins Flight Training LLC · Bakersfield, CABuilt 1951 · S/N 20219 N1777RKnur Ronald Glen · Elizabeth City, NCBuilt 1978 · S/N R18200555 N1778FBlake Brian R · Irvine, CABuilt 1966 · S/N 17255173 N1778MSeitz David C · Gordonville, TXS/N 21061958 N1778UMission Aviation Fellowship · Nampa, IDS/N 20700378 N1779DSchrag Jeremy M · Garden Plain, KSBuilt 1951 · S/N 20222 N1779MBlagg Kevin · Dumas, ARBuilt 1975 · S/N 18264439 N1779ZLewis Lionel · Tacoma, WABuilt 1963 · S/N 336-0079 N177AWolter Aviation LLC · Charleston, SCBuilt 1975 · S/N 17702284 N177AAKnowles Mark A · Gun Barrel City, TXBuilt 1975 · S/N 177RG0765 N177AMAdler A Michael · Bend, ORBuilt 1976 · S/N 177RG0941 N177APThunderbird Aviation LLC · Littleton, COBuilt 1972 · S/N 177RG0304 N177ARHull Jared Gene · Redondo Beach, CABuilt 1975 · S/N 177RG0782 N177ASManning Bryan E · Northport, ALBuilt 1968 · S/N 17700967 N177AVMy Airline LLC · Harrods Creek, KYBuilt 1976 · S/N 177RG0889 N177AWFarni Edward C III · Billings, MTBuilt 1970 · S/N 17701516 N177BStocks Aviation And Machine Inc · Wilmington, DES/N 17702350 N177BAAnderson David J · Saint Johns, FLS/N 17701449 N177BCCraig William Richard · Vandalia, OHBuilt 1972 · S/N 17701803 N177BDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281660 N177BGAccurso Steven M · Marietta, GAS/N 17702449 N177BHAircraft Trade Group LLC · Scandia, MNS/N 17701411 N177BLMontgomery David · Oak Park, ILBuilt 1976 · S/N 17702425 N177BSWilliams James E · Kirkwood, MOBuilt 1978 · S/N 177RG1017 N177BTPlane Data Inc · Terrell, NCBuilt 1977 · S/N 177RG1194 N177BVGhostrider Aviation Inc · Bohemia, NYS/N 177RG1288 N177BWRegistered aircraftBuilt 1972 · S/N 17701756 N177BZZotter Brand LLC · Vero Beach, FLBuilt 1971 · S/N 177RG0058 N177CCHoel Martin J · Waterloo, IABuilt 1967 · S/N 17700654 N177CELedley Charles F · Pasadena, MDBuilt 1978 · S/N 177RG1308

Back to AD 87-20-03 R2