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.

N6019PN6019p LLC · Washington, DCBuilt 1959 · S/N 24-1114N6022PRegistered aircraftBuilt 1959 · S/N 24-1117N6027PJourney Over Destination Aviation LLC · Golden, COBuilt 1959 · S/N 24-1122N6030PAngel Aviation LLC · Paradise, KSBuilt 1959 · S/N 24-1126N6032PStarrynight Bonanza Group LLC · Brighton, COBuilt 1959 · S/N 24-1128N6035PWhited Craig L · Redington Beach, FLBuilt 1959 · S/N 24-1131N6036PKoop Christopher N · Lake Orion, MIS/N 24-1132N6039PProcredential LLC · Raleigh, NCBuilt 1959 · S/N 24-1135N6040PWerner Christopher R · Anderson, CABuilt 1959 · S/N 24-1136N6043PRoberts Ronald L · Pismo Beach, CABuilt 1959 · S/N 24-1139N6045PEverroad Richard L · Bloomington, INBuilt 1959 · S/N 24-1141N6048PJohnson Keith A · Atlantic Beach, FLBuilt 1959 · S/N 24-1144N6049PMurolo Michael · Clancy, MTS/N 24-1145N6050PNeuman Michael R · Valencia, PABuilt 1959 · S/N 24-1146N6052POn Site Aviation Inc · Hillsboro, NDBuilt 1959 · S/N 24-1148N6054PMartinez Juan R · San Bruno, CABuilt 1959 · S/N 24-1150N6056PN6056p LLC · Sonoma, CABuilt 1959 · S/N 24-1152N6057PAerdonlen · Pensacola, FLBuilt 1959 · S/N 24-1153N6059PShearer Jay E · Coshocton, OHBuilt 1959 · S/N 24-1155N6062PYoung Tracy K · Newcomerstown, OHS/N 24-1158N6067PRoark William B · Silverdale, WABuilt 1959 · S/N 24-1163N6070PParcell Charles W · La Canada Flt, CABuilt 1959 · S/N 24-1166N6071PKohler Thomas M · Brant Beach, NJS/N 24-1167N6073PBradshaw James L · Lenoir, NCBuilt 1959 · S/N 24-1169N6074PBerlingen Michael W · Oregon City, ORBuilt 1959 · S/N 24-1170N6075PMoore Leslie D · Raymore, MOBuilt 1959 · S/N 24-1171N6079PColson Carl L · Blunt, SDBuilt 1959 · S/N 24-1177N6087PBrandner Paul D · Lake Tapps, WABuilt 1959 · S/N 24-1186N6089PMichaelsen Richard P · Sanborn, NYBuilt 1959 · S/N 24-1188N6090PBasin Franchising LLC · Vernal, UTBuilt 1959 · S/N 24-1189N6097PGuest Aviation LLC · Crane Hill, ALBuilt 1959 · S/N 24-765N60CSAir Flight Enterprises Inc · South Daytona, FLBuilt 1958 · S/N 24405N60WFEngels John · Edmond, OKBuilt 1959 · S/N 24-1635N6101PLockett Terrell M Sr · Winter Haven, FLBuilt 1959 · S/N 24-1199N6102PAllen Darren Kerr · Thomasville, GABuilt 1959 · S/N 24-1200N6104PKimsey Thomas W · Warner Robins, GABuilt 1959 · S/N 24-1202N6106PRegistration Pending · Mesa, AZRegistration pendingBuilt 1959 · S/N 24-1204N6112PBurnett Jennifer · Palmer, AKS/N 24-1212N6114PCompton Mark E · Garfield, KYBuilt 1959 · S/N 24-1214N6118PNovak Mark S · Dawson, NEBuilt 1959 · S/N 24-1218N6119PModisette Jeremy W · Baldwin, GABuilt 1959 · S/N 24-1219N611VProtain Jaden · Reno, NVBuilt 1959 · S/N 24-968N6120PDremel Ronald W · North Bend, PABuilt 1959 · S/N 24-1220N6121PSmith Gloria M · New Hampton, NYBuilt 1959 · S/N 24-1221N6126PDallas Jets Group LLC · Canton, TXBuilt 1959 · S/N 24-1226N6130PHiga Bertram · Northridge, CAS/N 24-1230N6134PJ-Tom Inc · Lincoln, NEBuilt 1959 · S/N 24-1234N6136PPlane Fun Inc Tr Trustee · Snellville, GABuilt 1959 · S/N 24-1236N613FPlane Fun Inc Tr Trustee · Snellville, GABuilt 1970 · S/N 39-45N6140PBrake It LLC · Pensacola, FLBuilt 1959 · S/N 24-1241
Back to AD 82-23-01 R1