OpenAirDocs.org
AD 82-23-01 R1

Registered aircraft · 3,118

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
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:82-23-01-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:82-23-01-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.

N5784PMiller Jeffery Allen · Menifee, CAS/N 24-863N5785PSmith Clyde R Jr · Lock Haven, PABuilt 1959 · S/N 24-864N5786PMckowan Sheila R · Chatsworth, CAS/N 24-865N5788Knot Speed Ltd · Wilmington, DEBuilt 1966 · S/N 24-4580N5789PNiche Pharmaceuticals LLC · Shorewood, MNBuilt 1959 · S/N 24-868N5792PLadet William D · Las Vegas, NVS/N 24-871N5798PCiotta Anton Albert · Wallingford, CTBuilt 1959 · S/N 24-878N5799PMorgan E Neal · San Diego, CABuilt 1959 · S/N 24-879N57AASouth Texas Weather Modification Association · Pleasanton, TXBuilt 1962 · S/N 24-3303N57DJPasserby Randal K · Mesa, AZS/N 30-1292N5800PCencula Christopher D · Roseville, CABuilt 1959 · S/N 24-880N5802PHass Morgan E · Lyons, ORBuilt 1959 · S/N 24-882N5804PWitt Aviation LLC · Naperville, ILBuilt 1959 · S/N 24-884N5805PGrace Family Fellowship Inc · Oklahoma City, OKBuilt 1959 · S/N 24-885N5807PRichter Dickinson Aviation LLC · Moultrie, GABuilt 1959 · S/N 24-887N5811PJpl Flyers LLC · Metairie, LABuilt 1959 · S/N 24-891N5822PJstream Lc · Sheridan, WYBuilt 1959 · S/N 24-903N5824PClaxton Fred E · La Habra, CABuilt 1959 · S/N 24-905N5825PRobles Carlos J · San Jose, CABuilt 1959 · S/N 24-906N5827PTwo Seven Papa LLC · Pueblo, COBuilt 1959 · S/N 24-908N5833PCochran Keith W · Long Beach, CAS/N 24-914N5835PLoya Francisco · Crestline, CAS/N 24-916N5836PShort Final LLC · Murfreesboro, TNBuilt 1959 · S/N 24-917N5837PGoodman Wayne A · Conway, SCBuilt 1959 · S/N 24-918N5838PHoughtling Marvin · Pasadena, TXBuilt 1959 · S/N 24-919N5842PFlyair Flight Academy LLC · Flint, TXBuilt 1959 · S/N 24-923N5844PKoniar Steven L · Newcastle, OKS/N 24-925N5845PGriffel Brandon T · Frederick, MDBuilt 1959 · S/N 24-926N5849PJinnis Flight Enterprises LLC · Montgomery, TXBuilt 1959 · S/N 24-930N5850PInto The Forest Equipment LLC · Placerville, CABuilt 1959 · S/N 24-932N5853PLewellen Walter G · Moreno Valley, CABuilt 1959 · S/N 24-935N5856PDemontalvo Aaron M · Mansfield, TXBuilt 1959 · S/N 24-938N5859PSnider Scott E · Turner, MTBuilt 1959 · S/N 24-941N5863PB E L Flight LLC · Punta Gorda, FLS/N 24-946N5865PLl Aviation LLC · Saint Joseph, MOBuilt 1959 · S/N 24-948N5866PBas Part Sales LLC · Greeley, COBuilt 1959 · S/N 24-949N5867PWickenheiser Kevin John · Detroit, MIBuilt 1959 · S/N 24-950N5870PPaul Eric C · Grapevine, TXBuilt 1959 · S/N 24-953N5871PHammons John A · Maurice, LABuilt 1959 · S/N 24-954N5882PEvans Gene · Henderson, TXBuilt 1959 · S/N 24-967N5885PCostanzo Christopher P · Staten Island, NYBuilt 1959 · S/N 24-970N5888PRegistered aircraftS/N 24-973N588CPTjomsland Bryan · Culver City, CABuilt 1958 · S/N 24-431N5890PDaniels David R · Anthony, NMBuilt 1959 · S/N 24-975N5896PBurwell Brent C · New Ulm, TXBuilt 1959 · S/N 24-983N58PJTaylor John W · Carrizo Springs, TXBuilt 1958 · S/N 24-225N5901PDavis Kevin L · Alvin, ILBuilt 1959 · S/N 24-986N5903PSpellman Henry A · Lincoln, ILBuilt 1959 · S/N 24-988N5906PHereford America Inc · Reva, SDBuilt 1959 · S/N 24-992N5907PSale Reported · St Francis, KSSale reportedBuilt 1959 · S/N 24-993
Back to AD 82-23-01 R1