N2812W, cancelled Mar 21, 2013
Service difficulty reports · 59
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N2812W' AND deregistration_id = 'N2812W-2013-03-21' ORDER BY difficulty_date DESC"
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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N2812W' AND deregistration_id = 'N2812W-2013-03-21' ORDER BY difficulty_date DESC
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.
SDR DL72W953283Skin · lightning strikeLT ELEVATOR, LIGHTNING DAMAGE L/E TO T/E OB OF TAB. REPAIRED PER SRM 55-20-3 FIG 4, FOUND AT HMV.SDR DL72W953264Web · crackedVERTICAL WEB INSIDE THE VERTICAL STAB CRACKED AT BASE OF RIB NR 1 AT LT AND RT LOWER CORNERS. REPAIRED PER SRM 53-10-4 FIG 17.SDR DL72W953262Frame · puncturedFRAME PUNCTURED AT FS 1050 TOP FLANGE ABOVE STR. 27R AND 27L. REPAIRED PER SRM 53-10-4 FIG 27.SDR DL72W953215Skin · gougedRT ELEVATOR GOUGED, .52 BY .1250 BY .040 ON LWR L/E, 2.5 FT I/B OF OB HINGE. REPAIRED PER SRM 55-20-3 FIG 4, FOUND AT HMV.SDR DL72W953214Te Skin · damagedRT ELEVATOR LIGHTNING DAMAGE ON O/B CORNER T/E. REPAIRED PER MM 55-20-0 PG 801, FOUND AT HMV.SDR DL72W953266Bracket · crackedNR 1 LE FLAP ACTUATOR MOUNT BRACKET CRACKED AT UPPER AND LOWER CORNERS. REPAIRED BRACKET PER MM 57-20-21 FIG 807.SDR DL72W953265Bracket · crackedNR 2 LE FLAP ACTUATOR AFT ATTACH BRACKETS ARE CRACKED ON ALL 4 CORNERS. REPAIRED PER MM 57-20-21 FIG 807.SDR DL72W952986Controller · faultyDURING CRUISE, AT FL 250 WITH SINGLE PACK OPERATION HAD CABIN ALTITUDE HORN. INITIATED EMERGENCY DESCENT, LANDED BOS. REPLACED LEFT PACK 35 DEG CONTROLLER, PACK OPERATION NORMAL.SDR DL72W951954Beam · crackedTHE RT TORQUE BOX UPPER TRANSVERSE BEAM AT FS 1273 WAS FOUND CRACKED. REPAIRS WERE ACCOMPLISHED PER S/B 53-0129.
Back to N2812W, cancelled Mar 21, 2013