OpenAirDocs.org
AD 67-23-01

Registered aircraft · 83

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:67-23-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:67-23-01')
  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.

N108MLosey Thomas L · Ft Myers, FLBuilt 1963 · S/N 281N111JRYoung Mark Allan · Sunnyvale, CABuilt 1967 · S/N 376N123RLBastiano Richard A · Elba, NYBuilt 1966 · S/N 321N15RRMcdonald Joseph T · Auburn, ALBuilt 1966 · S/N 332N184MHighland Holdings LLC · Bethlehem, PAS/N 282N189MWindh Steven R · Reedley, CABuilt 1963 · S/N 283N196MAvion Consulting LLC · Wilmington, DEBuilt 1964 · S/N 285N197MVrechek Joseph Rvt · Fort Lauderdale, FLS/N 286N19DHDiverse Aviation LLC · Cameron, TXBuilt 1963 · S/N 278N200DFlipper 1 LLC · Fort Lauderdale, FLBuilt 1967 · S/N 379N201GMSundale Aviation Inc · Erwinna, PABuilt 1966 · S/N 312N216MYbarra Jose · Atwater, CABuilt 1964 · S/N 290N220DPMyrick Richard Leon · Williamson, GABuilt 1966 · S/N 380N236MCameron Mark D · Alpine, WYBuilt 1965 · S/N 292N237MArdizzone Mark R · Mckinney, TXBuilt 1965 · S/N 293N239MWatkins Douglas · Yuba City, CABuilt 1965 · S/N 294N247MFsvc Aero Inc · Wilmington, DES/N 288N259MRidgerunner 51 LLC · Springdale, ARBuilt 1966 · S/N 297N260MSmith David W · Milaca, MNS/N 298N28PCGriesman Scott W · Sandy Valley, NVBuilt 1967 · S/N 377N2900TEwing Richard Jr · Antelope, CABuilt 1966 · S/N 301N2902THarber Gary · Melbourne, FLBuilt 1966 · S/N 303N2905TZephyr Enterprises Inc · Wilmington, DEBuilt 1966 · S/N 306N2908TRegistered aircraftBuilt 1966 · S/N 309N2909TSmith David W · Milaca, MNS/N 314N2912TKrahling Jeffrey B · Redding, CABuilt 1966 · S/N 318N2913TBlaine Christopher · Friday Harbor, WABuilt 1966 · S/N 319N2914TTp Aviation Inc · Augusta, KSBuilt 1966 · S/N 320N2916TLewis Paul A · Spring, TXBuilt 1966 · S/N 322N2919TParsons William Tony Jr · Medina, TNBuilt 1966 · S/N 325N2943TN2943t LLC · Fort Myers, FLBuilt 1966 · S/N 346N2961TMagnumforamen Ppg Aeroadventures LLC · Kalispell, MTBuilt 1966 · S/N 334N2962TAviation Days LLC · Ridgefield, CTBuilt 1966 · S/N 335N2964TMallard Aviation LLC · Manchester, NHBuilt 1966 · S/N 337N2966TThomas Paul J · Oakland, MDBuilt 1966 · S/N 339N2969TDoskicz Aircraft Specialties Inc · Bally, PABuilt 1966 · S/N 342N2971TWhitfield Robert O Jr · Hurdle Mills, NCBuilt 1966 · S/N 343N2972TTurnage Marvin E · Little Rock, ARBuilt 1966 · S/N 344N2975TSmith David W · Milaca, MNS/N 348N2976TMckay Ronye · Omaha, NEBuilt 1966 · S/N 349N2979TMays Stephen W · Carson City, NVBuilt 1966 · S/N 345N2980TMyers Thomas · Wills Point, TXBuilt 1966 · S/N 354N2981TKool-E5 LLC · Valdosta, GABuilt 1966 · S/N 355N2983TSlatter Lowell J · Buhl, IDBuilt 1966 · S/N 356N2987TDaly Arthur P · El Paso, TXBuilt 1966 · S/N 360N2988TSwiftmeyers LLC · Benton Harbor, MIBuilt 1966 · S/N 361N2989TMid America Museum Of Aviation And Transportation · Sioux City, IABuilt 1966 · S/N 362N2990TStahl Bradford C · Jackson, CAS/N 363N2991TRothgeb Michael A · Burns, ORBuilt 1966 · S/N 364N2992TMeyers 200 LLC · Malden, MOBuilt 1966 · S/N 365
Back to AD 67-23-01