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.

N8838YWaterwings Seaplanes LLC · Hoover, ALBuilt 1969 · S/N 30-1993N8839YMcguinness William V IV · Houston, TXBuilt 1969 · S/N 39-2N8840PStutzman John M · Grand Rapids, MIBuilt 1965 · S/N 24-4295N8841PBotsacos Chris S DBA · Long Beach, CABuilt 1965 · S/N 24-4296N8842PGauss Roger W · Forest Hill, MDBuilt 1965 · S/N 24-4297N8842YQuest Aviation Inc · Houlton, MEBuilt 1969 · S/N 30-2000N8843PRodarte Lionel A · Downey, CABuilt 1965 · S/N 24-4298N8844PReetz Roger D · Duluth, MNBuilt 1965 · S/N 24-4299N8844YStreater Aviation LLC · Weirsdale, FLBuilt 1969 · S/N 39-3N8846PLecrone Gregory S · Granbury, TXBuilt 1965 · S/N 24-4301N8847PSouth Texas Weather Modification Association · Pleasanton, TXBuilt 1965 · S/N 24-4302N8848PLazar Stephen D · Toledo, OHBuilt 1965 · S/N 24-4303N8848YBrunot Frank A · Spring Hill, FLBuilt 1969 · S/N 30-1907N8849PCare Management Oregon Inc · New Plymouth, IDBuilt 1965 · S/N 24-4304N884DCTanner Greg L · Bend, ORBuilt 1961 · S/N 24-2434N8850PSharp Alan D · Dallas, TXBuilt 1965 · S/N 24-4305N8851PRegistered aircraftBuilt 1965 · S/N 24-4307N8852YWikle Luther M · Laceys Spring, ALBuilt 1969 · S/N 39-7N8853PGebhart Kevin E · Burley, IDBuilt 1965 · S/N 24-4309N8854YSeeds John S Jr Trustee · Tequesta, FLBuilt 1970 · S/N 39-9N8855PTja Pop Ltd · Dix Hills, NYBuilt 1965 · S/N 24-4311N8857YLewis Leslie S · Glendale, AZBuilt 1970 · S/N 39-12N8858PMachmiller A A · San Jose, CABuilt 1965 · S/N 24-4315N8859PGowins John C · New Philadelphia, OHBuilt 1965 · S/N 24-4317N8861PForney Garry L · El Centro, CABuilt 1965 · S/N 24-4318N8864YMiller Donald W · Harrisonburg, VABuilt 1970 · S/N 39-19N8865PBrown Travis E · Leicester, NCBuilt 1965 · S/N 24-4322N8866PSale Reported · Caseville, MISale reportedBuilt 1965 · S/N 24-4323N8867YPiper Thirty Nine LLC · Glasgow, MTBuilt 1970 · S/N 39-22N8868PBurrough Haus Properties LLC · San Marcos, TXBuilt 1965 · S/N 24-4325N8869YCome Fly Away LLC · Waterloo, ILBuilt 1970 · S/N 39-24N8871PMq Flights LLC · Missoula, MTBuilt 1965 · S/N 24-4328N8872PBlackburn Robert F · Georgetown, TXBuilt 1965 · S/N 24-4329N8873PTailwind Auditing Group LLC · Godley, TXBuilt 1965 · S/N 24-4330N8874PWiebe Aron · Seminole, TXS/N 24-4331N8876PWentworth Douglas G · Simpsonville, KYS/N 244333N8876YComanche 76y LLC · Waynesboro, VAS/N 39-32N8877YVanhook Orville Richard · Somerset, KYBuilt 1970 · S/N 39-34N8878PHudson Albert Denning · Cornelius, NCBuilt 1965 · S/N 24-4337N887PMHarris William M · Radford, VABuilt 1970 · S/N 39-25N8880YPlane Fun Inc Tr Trustee · Snellville, GABuilt 1970 · S/N 39-38N8881PIce Randall R · Pierre, SDBuilt 1965 · S/N 24-4340N8883PFlynn James Jay · Seneca, SCBuilt 1965 · S/N 24-4342N8883YYank N Bank LLC · Greeley, COBuilt 1970 · S/N 39-41N8884YFlight Logistics LLC · Westerville, OHS/N 39-46N8885HHoughton Patrick K · Villa Rica, GABuilt 1961 · S/N 24-2577N8885YWilson Cecil · Lithonia, GABuilt 1970 · S/N 39-43N888LCDay Michael J · Fort Wayne, INBuilt 1964 · S/N 30-272N8890PElliott Charles · New Smyrna Beach, FLBuilt 1965 · S/N 24-4242N8891PTobias Ethan · West Haven, UTBuilt 1965 · S/N 24-4344
Back to AD 82-23-01 R1