AD 75-22-03

Registered aircraft · 131

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

N8388FUsda Aphis Ws Atoc · Cedar City, UTS/N 760838SN865HSRoyal Helicopter Services LLC · Exeter, CABuilt 1977 · S/N 1060865SN888DXAlexander Mary · Grants Pass, ORBuilt 1968 · S/N 380362N888USAm Air Service LLC · Green Oaks, ILBuilt 1968 · S/N 180282N9010FCody Richard A · Mclean, VABuilt 1969 · S/N 190004N9016FHigh Shines Inc · Earl Park, INBuilt 1969 · S/N 890111SN9020FSideline Services LLC · Pearland, TXBuilt 1969 · S/N 1090203EN9034FStuart Aviation Inc · Wilmington, DEBuilt 1969 · S/N 790105SN9052FMotivated Air LLC · Felton, DEBuilt 1970 · S/N 1290225SN9107FUp Rite Aviation LLC · Zeeland, MIBuilt 1972 · S/N 320370SN9113QSea Corp Helicopters Inc · Wilmington, DEBuilt 1976 · S/N 260794SN9117HBrown Helicopter Inc · Pensacola, FLBuilt 1969 · S/N 791239N9118FCook Jeffrey G Trustee · Ventura, CABuilt 1972 · S/N 720397SN911HUUsda Aphis Ws Atoc · Cedar City, UTS/N 191001N911JXSt Louis County Police · Chesterfield, MOS/N 601424N9132FHorizon Aviation LLC · Glastonbury, CTBuilt 1973 · S/N 230446SN9146FBerling Robert E · Mooresville, INBuilt 1973 · S/N 830508SN9166FNorthstar Marine LLC · Lewes, DEBuilt 1973 · S/N 830510SN9176F76f LLC · Calhoun, GABuilt 1974 · S/N 340569SN9177FRotor View Inc · Wilmington, DEBuilt 1973 · S/N 430465SN9196FAsbill Jimmy T · Winnsboro, TXBuilt 1974 · S/N 740616SN9233FC & D Helicopters LLC · Spanish Fork, UTBuilt 1975 · S/N 350715SN9260FRjo LLC · Kenansville, FLBuilt 1975 · S/N 450741SN9267FManulwa Airways Inc · Hilo, HIBuilt 1975 · S/N 1150778SN926ESRoyal Helicopter Services LLC · Exeter, CABuilt 1974 · S/N 940641SN9677NDat Aircraft LLC · Lewes, DEBuilt 1974 · S/N 1020422SN9792SGrand Haven Aviation Services · Spring Lake, MIBuilt 1966 · S/N 1060007N98369Diamond X LLC · Elko, NVS/N 109-0114SN990SRBlue Penguin LLC · Lockhart, TXBuilt 1973 · S/N 230452SN99888Combat Rotors LLC · Eugene, ORBuilt 1969 · S/N 391105N9HAMiracle Robert B Sr · Perkasie, PABuilt 1973 · S/N 730503S
Back to AD 75-22-03