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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N191CEBrones Jon P · Blanco, TXN192BPJones Flying Service · Biggs, CAN19CFPowers Michael · Granbury, TXN19SPNew York State Police · Albany, NYN1MXWsh LLC · Palmer, AKN20446Agriforrestal Applications Inc · Arcadia, FLN2048PNorthwest Helicopters LLC · Olympia, WAN204AQTamarack Helicopters Inc · Stevensville, MTN204BMToucan Helicopter Co Ltd · Fayetteville, GAFirst renewal noticeN204BSIntermountain Helicopters Inc · Cottage Grove, ORN204DSGreenwood Helicopters Inc · Washington, NCN204DXFarwest Aviation LLC · Billings, MTN204GPJones Aviation Inc · Biggs, CAN204HTJones Flying Service · Biggs, CAN204JBPremier Aircraft Services LLC · Bakersfield, CAN204NWNorthwest Helicopters LLC · Olympia, WAN204RARotak LLC · Anchorage, AKN204UHR&R Conner Aviation LLC · Conner, MTN2055VBrown Helicopter Inc · Pensacola, FLN205ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN205BDVentus Ff LLC · Boise, IDN205BTRedding Air Service Inc · Redding, CAN205CESouthern California Edison Co · Rosemead, CAN205DPDillon Uh-1h LLC · Scottsdale, AZN205DYIdaho Helicopters Inc · Boise, IDN205FUAir 1 LLC · Newark, DEN205FWPasco Sheriffs Office · New Port Richey, FLN205GEAv8-Orr Helicopter Services Inc · Hamilton, MTN205GFGeorgia Forestry Commission · Macon, GAN205GHRotorcraft Support Inc · Fillmore, CAN205HQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN205KPSchaper Monte E · Terra Bella, CAN205KSUsda Forest Service Fepp · Santa Barbara, CAN205LECollier County Sheriffs Office · Naples, FLN205LMVentus Ff LLC · Boise, IDN205RHSacramento Executive Helicopters Inc · Rancho Cordova, CAN205TARoberts Aircraft LLC · Cheyenne, WYN205TKCoastal Helicopters LLC · La Verne, CAN205VCVentura County Sheriffs Department · Camarillo, CAN205WWBlades LLC · Arlington, WAN206NJPope James D · Clarkston, WAN207SDU S Dept Of State Inl/A · Melbourne, FLN211GHGuardian Helicopters Inc · Fillmore, CAN211NWOlympic Jet Inc · Olympia, WAN21221Bank Of Utah Trustee · Salt Lake City, UTN21225Bank Of Utah Trustee · Salt Lake City, UTN21240Bank Of Utah Trustee · Salt Lake City, UTN212AHAspen Helicopters Inc · Oxnard, CAN212BTRedding Air Service Inc · Redding, CAN212DFState Of Nevada · Reno, NV
Back to AD 92-23-01