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.

N7338PPope Kent M · Hayden, IDBuilt 1961 · S/N 24-2517N733GPHorton Luther · Lakeland, FLBuilt 1962 · S/N 24-3213N7340PWard James A · Brentwood, TNBuilt 1961 · S/N 24-2519N7341PBlaes Richard S · Columbus, OHBuilt 1960 · S/N 24-2520N7342YHinkle Anthony · Mineola, TXBuilt 1964 · S/N 30-392N7344PWorley Jimmy · Dallas, TXBuilt 1961 · S/N 24-2522N7347PVan Eyck Christopher · Cottonwood, CABuilt 1961 · S/N 24-2525N7348PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1961 · S/N 24-2526N7349PMathison John M · Vancouver, WABuilt 1961 · S/N 24-2527N7351PSutliff Larrie G · Briarcliff Manor, NYBuilt 1961 · S/N 24-2529N7354YBreum Todd R · Billings, MTBuilt 1964 · S/N 30-408N7355PGo Fly Az LLC · Gilbert, AZBuilt 1961 · S/N 24-2533N7357PMelvin Ryan C · Hamilton, GABuilt 1961 · S/N 24-2535N7358YPmx Aviation Services LLC · Kailua Kona, HIBuilt 1964 · S/N 30-413N7359YAwmr LLC · Conroe, TXBuilt 1964 · S/N 30-414N7362PMead Gary M · Lubbock, TXBuilt 1961 · S/N 24-2540N7363PJansen David C · Newnan, GABuilt 1961 · S/N 24-2541N7364PMarotta Thomas E · Twin Lake, MIS/N 24-2542N7365YLoguidice Anthony · Bethlehem, PABuilt 1964 · S/N 30-416N7366PAnthony Craig D · Keller, TXBuilt 1961 · S/N 24-2544N7366YShockley Kenlon D · Aurora, COBuilt 1964 · S/N 30-417N7368YHoenmans John P · Roseville, CABuilt 1964 · S/N 30-419N7369PGrier Randall · Owasso, OKBuilt 1961 · S/N 24-2549N7370PLeesman Raleigh R · Blunt, SDBuilt 1961 · S/N 24-2550N7371PJsntg Inc · Wilmington, DEBuilt 1961 · S/N 24-2552N7372PArnold Matthew C · Alpine, CABuilt 1961 · S/N 24-2553N7374PFerland Jeffrey B · San Francisco, CABuilt 1961 · S/N 24-2555N7375PSmith Happy E · Rogersville, TNBuilt 1961 · S/N 24-2556N7375YTwinco Aviation LLC · Kalispell, MTS/N 30-428N7376PWelch Robert W · Harper, KSBuilt 1961 · S/N 24-2557N7378YJohnson Bruce L · Oklahoma City, OKBuilt 1964 · S/N 30-433N7379PGlick William R · Newark, OHBuilt 1961 · S/N 24-2560N7379YRegistered aircraftBuilt 1964 · S/N 30-282N7381PPax River Flyers LLC · Kennett Square, PABuilt 1961 · S/N 24-2562N7384YMccafferty Robert S · Duluth, GABuilt 1964 · S/N 30-438N7385PAbughazaleh Ziad · Altadena, CABuilt 1961 · S/N 24-2566N7386YAlbee Philip · Cameron Park, CABuilt 1964 · S/N 30-440N7387YLillquist Brien I · Oak Harbor, WABuilt 1964 · S/N 30-442N7388YForward Aero LLC · Thomasville, PABuilt 1964 · S/N 30-443N7389PNordic Elevated Inc · Eden, UTBuilt 1961 · S/N 24-2573N7389YPascoe Aviation Inc · Gulf Breeze, FLBuilt 1964 · S/N 30-444N7390PGreen William A · Memphis, TNBuilt 1961 · S/N 24-2574N7391YAeronautical Technical Service Inc · Collierville, TNS/N 30-447N7392PGray Matthew R · Haymarket, VABuilt 1961 · S/N 24-2576N7394PWhittle Mark A · Crestview, FLBuilt 1961 · S/N 24-2578N7396YAllen Charles M · Puryear, TNBuilt 1964 · S/N 30-454N7399PPache Keith M · Montgomery, TXBuilt 1961 · S/N 24-2583N73TLucid Thought Consulting LLC · Terre Haute, INBuilt 1971 · S/N 24-4991N73ZFlying Rocks LLC · Sparkill, NYFirst renewal noticeBuilt 1964 · S/N 30-359N7400YWright Amos L Jr · Enterprise, ALBuilt 1964 · S/N 30-457
Back to AD 82-23-01 R1