AD 92-23-01

Registered aircraft · 478

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:92-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:92-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.

N191CEBrones Jon P · Blanco, TXS/N 66-17061N192BPJones Flying Service · Biggs, CABuilt 1965 · S/N 65-10133N19CFPowers Michael · Granbury, TXS/N 66-01145N19SPNew York State Police · Albany, NYS/N 64-13666N1MXWsh LLC · Palmer, AKS/N 62-01995N20446Agriforrestal Applications Inc · Arcadia, FLBuilt 1963 · S/N 63-8770N2048PNorthwest Helicopters LLC · Olympia, WAS/N 65-9602N204AQTamarack Helicopters Inc · Stevensville, MTS/N 2198N204BMToucan Helicopter Co Ltd · Fayetteville, GAFirst renewal noticeS/N 68-15683N204BSIntermountain Helicopters Inc · Cottage Grove, ORBuilt 1963 · S/N 63-8699N204DSGreenwood Helicopters Inc · Washington, NCBuilt 1960 · S/N 60-3594N204DXFarwest Aviation LLC · Billings, MTS/N 61-787N204GPJones Aviation Inc · Biggs, CABuilt 1964 · S/N 64-14073N204HTJones Flying Service · Biggs, CABuilt 1962 · S/N 62-2078N204JBPremier Aircraft Services LLC · Bakersfield, CABuilt 1963 · S/N 63-13088N204NWNorthwest Helicopters LLC · Olympia, WAS/N 2050N204RARotak LLC · Anchorage, AKBuilt 1965 · S/N 2034N204UHR&R Conner Aviation LLC · Conner, MTBuilt 1962 · S/N 62-2034N2055VBrown Helicopter Inc · Pensacola, FLBuilt 1966 · S/N 66-1023N205ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1974 · S/N 30161N205BDVentus Ff LLC · Boise, IDBuilt 1971 · S/N 30097N205BTRedding Air Service Inc · Redding, CABuilt 1974 · S/N 30173N205CESouthern California Edison Co · Rosemead, CABuilt 1980 · S/N 30301N205DPDillon Uh-1h LLC · Scottsdale, AZBuilt 1968 · S/N 68-16056N205DYIdaho Helicopters Inc · Boise, IDBuilt 1978 · S/N 30282N205FUAir 1 LLC · Newark, DEBuilt 1970 · S/N 70-16416N205FWPasco Sheriffs Office · New Port Richey, FLS/N 69-15585N205GEAv8-Orr Helicopter Services Inc · Hamilton, MTBuilt 1969 · S/N 69-15198N205GFGeorgia Forestry Commission · Macon, GABuilt 1979 · S/N 30300N205GHRotorcraft Support Inc · Fillmore, CABuilt 1968 · S/N 30014N205HQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1970 · S/N 30100N205KPSchaper Monte E · Terra Bella, CAS/N 62-02108N205KSUsda Forest Service Fepp · Santa Barbara, CAS/N 9526N205LECollier County Sheriffs Office · Naples, FLS/N 69-15533N205LMVentus Ff LLC · Boise, IDBuilt 1974 · S/N 30213N205RHSacramento Executive Helicopters Inc · Rancho Cordova, CABuilt 1973 · S/N 30127N205TARoberts Aircraft LLC · Cheyenne, WYBuilt 1974 · S/N 30168N205TKCoastal Helicopters LLC · La Verne, CABuilt 1973 · S/N 30131N205VCVentura County Sheriffs Department · Camarillo, CABuilt 1969 · S/N 30066N205WWBlades LLC · Arlington, WABuilt 1980 · S/N 30329N206NJPope James D · Clarkston, WABuilt 1962 · S/N 62-1934N207SDU S Dept Of State Inl/A · Melbourne, FLS/N 74-22359N211GHGuardian Helicopters Inc · Fillmore, CAS/N 30058N211NWOlympic Jet Inc · Olympia, WABuilt 1975 · S/N 30177N21221Bank Of Utah Trustee · Salt Lake City, UTBuilt 1976 · S/N 30773N21225Bank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 31183N21240Bank Of Utah Trustee · Salt Lake City, UTBuilt 1976 · S/N 30783N212AHAspen Helicopters Inc · Oxnard, CABuilt 1979 · S/N 30959N212BTRedding Air Service Inc · Redding, CABuilt 1978 · S/N 30870N212DFState Of Nevada · Reno, NVBuilt 1975 · S/N 30676
Back to AD 92-23-01