OpenAirDocs.org
AD 66-19-04

Registered aircraft · 76

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

N1043TCroman Corp · White City, ORBuilt 1961 · S/N 61083N1048YCroman Corp · White City, ORBuilt 1961 · S/N 61161N1168UHeli-Flite Inc · Corona, CABuilt 1958 · S/N 58-1070N126GWAircrane Inc · Winder, GABuilt 1959 · S/N 581124N129NHSh1p Holdings LLC · Wichita, KSBuilt 1958 · S/N 58-855N138ARAmentum Services Inc · West Palm Beach, FLBuilt 1977 · S/N 61767N161CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1968 · S/N 61363N232ACAmentum Services Inc · West Palm Beach, FLBuilt 1969 · S/N 61470N261CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1985 · S/N 61257N3173USiller Helicopters LLC · Chamblee, GABuilt 1963 · S/N 61186N408FSCroman Corp · White City, ORBuilt 1966 · S/N 61361N408UDCroman Corp · White City, ORBuilt 1974 · S/N 61772N408WCCroman Corp · White City, ORBuilt 1977 · S/N 61764N410GHCroman Corp · White City, ORBuilt 1975 · S/N 61749N4247VSh1p Holdings LLC · Wichita, KSS/N 58-1547N4263ACroman Corp · White City, ORBuilt 1966 · S/N 61551N448JSBank Of Utah Trustee · Salt Lake City, UTBuilt 1968 · S/N 61428N471WRCoulson Aviation USA Inc · Portland, ORBuilt 1969 · S/N 61471N476AWConstruction Helicopters LLC · Howell, MIBuilt 1971 · S/N 61476N4XY5-State Helicopters Inc · Royse City, TXBuilt 1957 · S/N 58700N504Vi 1 LLC · Brewster, WABuilt 1957 · S/N 57-1717N504DHVan Surdam John R · Seneca, SCBuilt 1958 · S/N 58814N506Vi 1 LLC · Brewster, WAS/N 14-8079N5193YAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1963 · S/N 61-184N589SSh1p Holdings LLC · Wichita, KSBuilt 1957 · S/N 58-0740N58AHB&B Helos LLC · Perris, CABuilt 1956 · S/N 58-328N58HFVi 1 LLC · Brewster, WABuilt 1957 · S/N 571692N58HUVi1 LLC · Brewster, WABuilt 1963 · S/N 58-1575N58KKVi 1 LLC · Brewster, WABuilt 1957 · S/N 58462N58NSVi 1 LLC · Brewster, WABuilt 1960 · S/N 58-1453N58SAircrane Inc · Winder, GABuilt 1962 · S/N 58-1539N614CKCroman Corp · White City, ORBuilt 1974 · S/N 61715N617CKCroman Corp · White City, ORBuilt 1962 · S/N 61164N618CKCroman Corp · White City, ORS/N 61454N619CKCroman Corp · White City, ORS/N 61808N61NHCroman Corp · White City, ORBuilt 1970 · S/N 61474N61NWUS Leaseco Inc · Aurora, ORBuilt 1974 · S/N 61719N620CKCroman Corp · White City, ORS/N 61362N621CKCroman Corp · White City, ORS/N 61364N623CKCroman Corp · White City, ORBuilt 1977 · S/N 61762N624CKCroman Corp · White City, ORBuilt 1964 · S/N 61272N625CKCroman Corp · White City, ORBuilt 1963 · S/N 61-216N626CKCroman Corp · White City, ORBuilt 1963 · S/N 61220N627CKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 61824N629CKCroman Corp · White City, ORBuilt 1975 · S/N 61751N631CKCroman Corp · White City, ORS/N 61753N6BL5 State Helicopters Inc · Royse City, TXBuilt 1962 · S/N 581567N703HGConstruction Helicopters LLC · Howell, MIBuilt 1972 · S/N 61703N703SCVi 1 LLC · Brewster, WABuilt 1963 · S/N 581607N712HGConstruction Helicopters LLC · Howell, MIBuilt 1973 · S/N 61712
Back to AD 66-19-04