N918UP, cancelled Nov 21, 2007
Service difficulty reports · 135
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 = 'N918UP' AND deregistration_id = 'N918UP-2007-11-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 = 'N918UP' AND deregistration_id = 'N918UP-2007-11-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 UPS203813Floorbeam · corrosionWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON FLOORBEAM STA 640, RBL 29 TO 60, WL 208, AFT SIDE OF UPPER CHORD. REPAIRED IAW SRM 51-30-2, 51-10-8.SDR UPS203812Frame · corrosionWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON WEB UPPER SIDE AND END FRAME OF AFT CARGO FLOOR. REPAIRED IAW SRM 51-20-3, 51-40-2, 51-10-1.SDR UPS203811Floorbeam · corrosionWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON FLOORBEAM UNDERSIDE OF UPPER CHORD AT STA 740, BL 0-LBL 25, WL 208.5. REPAIRED IAW SRM 53-10-1, 51-30-5, 51-30-2, 51-10-1.SDR UPS203810Rib · crackedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CRACKED UPPER RIB CHORD AT FWD VENT BOX FWD FLANGE 7 INCHES AFT OF FRONT SPAR ON LEFT WING AT STA 171.5. REPAIRED IAW SRM 51-40-04.SDR UPS203809Rib · crackedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CRACKED RIGHT WING NR 5 SLAT ACTUATOR O/B RIB AT FWD END OF SLAT ACTUATOR ROD END ATTACHING RIB. REPLACED IAW SRM 51-10-1.SDR UPS203808Floorbeam · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION AROUND NUTPLATE HOLES ON FLOORBEAMS AT STA 312 AND 328, BL 0 TO LBL 60, WL 208. REPAIRED IAW SRM 51-10-2, 51-20-4, 53-10-8, 53-10-1, M/M 51-20-151.SDR UPS203807Floorbeam · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON FLOORBEAM LOWER FLANGE FWD SIDE AT STA 910 WL 200 RBL 25-RBL 55. REPAIRED IAW SRM 51-30-2, 51-10-2, 51-20-4, 53-10-8.SDR UPS203806Web · crackedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CRACK EMITTING FROM FASTENER HOLE IN WEB AT STA 259.5 WL 192.5 LBL 21. REPAIRED IAW SRM 53-10-02, 51-30-2, 51-40-02.SDR UPS203801Floor Beam · corrodedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION FLOOR BEAM STA 680, RBL 37-60, WL 208 UPPER AND LOWER SIDE OF UPPER CHORD.SDR UPS203800Beam · corrodedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION AROUND SEVERAL NUTPLATE HOLES ON UNDERSIDE LONGITUDINAL BEAM AT BS 760-850, RBL 45, WL 208. REPAIRED IAW SRM 51-10-1, 53-10-1, 53-10-2.SDR UPS203799Beam · corrodedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION AROUND SEVERAL NUTPLATE HOLES ON UNDERSIDE LONGITUDINAL BEAM AT BS 760-850, LBL 25, WL 208. REPAIRED IAW SRM 53-10-1, 51-10-6, 51-10-2, M/M 51-20-00.SDR UPS203798Beam · corrodedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION AROUND SEVERAL NUTPLATE HOLES ON UNDERSIDE LONGITUDINAL BEAM AT BS 760-850, LBL 45, WL 208. REPAIRED IAW SRM 53-10-1, 51-10-6, 51-10-2, M/M 51-20-00.SDR UPS203797Stub Beam · corrodedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION AROUND FASTENER HOLES ON STUB BEAM AT BS 762, LBL 55 UNDERSIDE WL 207. REPAIRED IAW SRM 51-40-4.SDR UPS203796Seat Track · corrodedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORRODED SEAT TRACK STRAPS STA 472-480, LBL 45, WL 208. REPLACED IAW SRM 51-30-2, M/M 51-20-151.SDR UPS203795Clip · crackedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CRACKED STRINGER CLIPS STA 1070 STR 5, 8 RT. REPLACED IAW SRM 51-30-2, 51-10-1.SDR UPS203794Clip · crackedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CRACKED STRINGER CLIPS STA 1010 STR 6, 8 RT. REPLACED IAW SRM 51-30-2.SDR UPS203793Stiffener · crackedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CRACKED LOWER SKIN STIFFENER ON RT ELEVATOR AT ELEV STA 17.2 INSIDE ACCESS PANEL 9406 APPROX 5.25 INCHES AFT OF FRONT SPAR CHORD. REPAIRED IAW SRM 51-20-2, 51-30-2, 51-20-1, 55-20-2.SDR UPS203792Foreflap · delaminatedWHILE IN FOR SI CHECK, MAINTENANCE FOUND DELAMINATION OF LT I/B FOREFLAP UNDER RUB STRIP ON I/B END. REPAIRED IAW M/M 51-51-11.SDR UPS203791Tab · delaminatedWHILE IN FOR SI CHECK, MAINTENANCE FOUND DELAMINATION OF UPPER RUDDER TAB (SEVEN AREAS), CORE CONTAMINATED WITH WATER. REPAIRED IAW SRM 51-40-6, M/M 51-20-151.SDR UPS203790Skin · corrosionWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION AROUND NUTPLATE HOLES STA 420, LBL 45 TO 62.5, WL 208. REPAIRED IAW SRM 53-10-8.SDR UPS203789Floor Beam · corrosionWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION AROUND NUTPLATE HOLES ON TOP FLANGE OF FLOOR BEAM STA 344, RBL 52 - LBL 46, WL 208. REPAIRED IAW SRM 51-30-2, 53-10-8, 51-10-6.SDR UPS203788Intercostal · corrosionWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION AROUND NUTPLATE HOLES ON INTERCOSTAL STA 304-344, LBL 30, WL 208. REPAIRED IAW SRM 51-30-2, 53-10-1, 51-10-2, M/M 51-20-15.SDR UPS203787Web · crackedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CRACK ON HORIZ. WEB BETWEEN FRAME AT 348 TO 360, LT WL 216. REPAIRED IAW SRM 51-10-07, M/M 51-20-151, SRM 51-40-2.SDR UPS203786Floor Beam · corrodedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION ON CREASE BEAM BS 306-312 RBL 56, WL 208 AT FLOORBOARD FASTENER HOLES. REPAIRED IAW SRM 51-40-3.SDR UPS203785Stiffener · corrodedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION ON STIFFENER ON SIDE PANEL OF NOSE GEAR WHEELWELL (INSIDE DOG HOUSE) BS 320, RBL 14, WL 182. REPLACED IAW SRM 51-10-1, 51-30-2, 51-20-4.SDR UPS203784Web · corrodedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION ON TOP EDGE OF STA 870 WHEELWELL WEB RBL 0-65 WL 178. REPAIRED IAW SRM 53-10-9, 51-30-2.SDR UPS203783Stiffener · corrodedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION ON STIFFENER AT BS 302, WL 180, ON TOP OF PANEL OF NOSE GEAR WELL RBL 3. REPLACED IAW SRM 51-30-2, 51-30-5.SDR UPS203782Stringer · corrodedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION ON TOP STRINGER FLANGE AT BS 488, STR 24 LT WL 165. REPAIRED IAW SRM 53-10-3, 51-30-2, M/M 51-20-151.SDR UPS203781Angle · corrodedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION ON INTERCOSTAL AND SUPPORT ANGLE BETWEEN END FRAME AND NR 1 TRANSVERSE BEAM 15 INCHES FWD OF AFT EDGE. REPAIRED IAW SRM 53-10-1, 51-30-2, 51-10-6.SDR UPS203780Retainer · crackedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CRACKED L/W O/B MID-FLAP AFT LOWER CHORD AND ATTACHED BULB SEAL RETAINER 21 INCHES FROM O/B END. REPAIRED IAW SRM 51-10-1, 51-30-2.SDR UPS203779Static Wick · corrodedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION ON ELEVATOR O/B STATIC WICK BASE. REPAIRED IAW SRM 55-20-3, M/M 51-20-21, 51-20-31, 51-20-13, 23-61-00.SDR UPS203778Frame · crackedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CRACK ON FLANGE OF FRAME AT BS 340, BETWEEN STR 11 AND STR 12R BEHIND SIDE WALL SUPPORT. REPAIRED IAW SRM 51-40-3, 51-10-2, 51-30-2.SDR UPS203777Frame · corrodedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION ON FRAME AT STA 1130, STR 8-10, RT SIDE. REPAIRED IAW SRM 51-40-3, 53-10-1, 51-10-2, M/M 51-20-151.SDR UPS203776Intercostal · corrodedWHILE IN FOR SI CHECK, MAINTENANCE FOUND CORROSION ON INTERCOSTAL AT B.S. 240-250, RT WL 185, RBL 42. REPAIRED IAW SRM 51-20-01, 20-43-03, 20-44-04, 51-30-2.SDR UPS201920Warn Lights · malfunctionPILOT REPORTED LEFT MAIN GEAR DOOR INDICATED NOT UP AND LOCKED ON FLIGHT DECK GEAR PANEL. LIGHT EXTINGUISHED ON F/E PANEL. CHECKLIST WAS C/W AND THE GEAR WAS EXTENDED AND RETRACTED. BOTH LIGHTS DID NOT GO OUT. CLEANED LEFT GEAR DOOR SWITCH AND CHECKED SECU
Back to N918UP, cancelled Nov 21, 2007