N283SC, cancelled Dec 3, 2002
Service difficulty reports · 120
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 = 'N283SC' AND deregistration_id = 'N283SC-2002-12-03' 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 = 'N283SC' AND deregistration_id = 'N283SC-2002-12-03' 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 SCNA96109Blkhd Stiffener · corrodedDURING HEAVY MAINTENANCE VISIT, CORROSION WAS FOUND ON AFT PRESSURE BULKHEAD STIFFENER, BS 1183 RBL 61, WL 220. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR IN ACCORDANCE WITH B727 SRM 51-40-4.SDR SCNA96119Frame · corrodedDURING HEAVY MAINTENANCE VISIT, CORROSION WAS FOUND ON A FRAME IN THE AFT PIT AT BS 1110 TO 1130, BL 0, WL 208.1. REMOVED CORROSION, FABRICATED AND INSTALLED AN ANGLE IN ACCORDANCE WITH B727 SRM 51-30-2, 51-20-1 AND MM 51-20-11.SDR SCNA96117Frame · corrodedDURING HEAVY MAINTENANCE VISIT, CORROSION WAS FOUND ON A FRAME IN THE AFT PIT BETWEEN BS 1090 AND BS 1110, AT LBL 12, WL 208.1. REMOVED CORROSION, FABRICATED AND INSTALLED A NEW SUPPORT AND STRAP IN ACCORDANCE WITH B727 SRM 53-10-2 AND MM 51-20-11.SDR SCNA96116Angle · crackedDURING HEAVY MAINTENANCE VISIT, A CRACK WAS FOUND EXTENDING FROM A FASTENER LOCATION IN THE LEFT MLG WW LOWER CHORD AT BS 870 LBL 50. REMOVED TWO CRACKED ANGLES, FABRICATED AND INSTALLED NEW ANGLES IN ACCORDANCE WITH B727 SRM 51-30-2 AND 51-40-3 FIGURE 1.SDR SCNA96125Angle · crackedDURING HEAVY MAINTENANCE VISIT, CRACKS WERE FOUND IN TWO SUPPORT ANGLE BRACKETS LOCATED AT THE NR 4 SLAT IN THE LEFT WING. FABRICATED AND INSTALLED TWO REPAIR DOUBLERS IN ACCORDANCE WITH B727 SRM 27-81-11, OPS CHECKED OK.SDR SCNA96124Bulkhead Strap · crackedDURING HEAVY MAINTENANCE VISIT, CRACKS WERE FOUND IN THE FORWARD BULKHEAD STRAP/SKIN BETWEEN THE 2ND, 3RD, 4TH, AND 5TH FASTENERS AT BS 178, BL ZERO, WL 183. FABRICATED A REPAIR DOUBLER AND STRAP IN ACCORDANCE WITH B727 SRM 51-30-2, AND SB 727-23-0065.SDR SCNA96083Skin · crackedDURING HEAVY MAINTENANCE VISIT A CRACK WAS DISCOVERED IN THE SKIN AT THE BOTTOM FASTENER IN THE NOSE LANDING GEAR WHEELWELL, LEFT SIDE, APPROXIMATE BS 268.25, WL 148. STOP DRILLED CRACK, FABRICATED AND INSTALLED A DOUBLER AND STRAP REPAIR IN ACCORDANCE WITH BSDR SCNA96082Skin · crackedDURING HEAVY MAINTENANCE VISIT A CRACK WAS DISCOVERED IN THE SKIN AT THE BOTTOM FASTENER IN THE NOSE LANDING GEAR WHEELWELL, RIGHT SIDE, APPROXIMATE BS 268.25, WL 148. STOP DRILLED CRACK, FABRICATED AND INSTALLED A DOUBLER AND STRAP REPAIR IN ACCORDANCE WITH SDR SCNA96012Floorbeam · corrodedDURING SCHEDULED INSPECTION, FOUND LEVEL 2 CORROSION ON THE UPPER CAP OF THE THIRD CREWMANS SEAT FLOORBEAM INSTALLATION. REMOVED AND REPLACED THE UPPER CAP STA 266.75 LBL 8.5 TO RBL 21 AND INTERCOSTAL STA 259.5 TO 277 LBL 13.5.SDR SCNA95280Eel Lamp · failedTHE AFT EMERGENCY EXIT DOOR SIGN WAS FOUND TO BE INOPERATIVE. RELAMPED LIGHT AND UNIT OPS CHECKED GOOD.SDR SCNA95275N2 Rotor · lockedTHE NR 1 ENGINE WAS SHUTDOWN IN-FLIGHT DUE TO A LOCKED N2 ROTOR. REMOVED AND REPLACED THE NR 1 ENGINE.SDR SCNA95237Eel Battery Pack · dischargedTHE RIGHT CENTER OVERWING EMERGENCY LIGHT TESTED DIM. REMOVED AND REPLACED BATTERY PACK IAW MM 33-50-22 AND LIGHT TESTED GOOD.SDR SCNA95236Eel Batteries · dischargedTHE COCKPIT PORTABLE EMERGENCY LIGHT TESTED DIM. REMOVED AND REPLACED BATTERIES IAW MM 33-50-101 AND LIGHT TESTED GOOD.SDR SCNA95189Eel · failedTHE L-1 PORTABLE EMERGENCY EXIT LIGHT REMAINED ON WHEN SWITCH TURNED TO OFF POSITION. REMOVED AND REPLACED L-1 PORTABLE EMERGENCY EXIT LIGHT PER MM 33-50-101, LIGHT TESTED GOOD.SDR SCNA95164Eel Battery Pack · dischargedTHE FORWARD OVERHEAD EMERGENCY LIGHT WAS FOUND BLINKING. REPLACED BATTERY IN THE EMERGENCY LIGHT, UNIT TESTED GOOD.SDR SCNA95131Eel Battery Pack · dischargedFOUND THE AFT SECTION OF EMERGENCY FLOOR TRACK LIGHTING INOPERATIVE. REMOVED AND REPLACED BATTERY PACK AND TRACK LIGHTING TESTED GOOD.SDR SCNA95130Eel Battery Pack · dischargedFOUND THE FORWARD OVERHEAD EMERGENCY EXIT SIGN INOPERATIVE. REPLACED BATTERY PACK, LIGHT OPS CHECKED NORMAL.SDR SCNA95095Eel Battery · dischargedFORWARD CEILING MOUNTED AREA EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED SELF-CONTAINED BATTERY. OPS CHECK GOOD IAW MM 33-50-81.SDR SCNA95059Floor Beam · corrodedDURING C-CHECK, THE FLOOR BEAM AND WEB LOCATED AT BS 344, LBL 5 TO RBL 5 WAS FOUND WITH CORROSION. REPAIR MEMBERS WERE FABRICATED AND INSTALLED IAW B727 SRM 53-10-8.SDR SCNA95035L-1 Window · faultyWINDOW HEAT CONDUCTOR, UPPER LEFT L-1 WINDOW, ARCHING AND SMOKE NOTED. TURNED OFF L-1 AND L-2 WINDOW HEAT, CONDITION STOPPED. REPLACED L-1 WINDOW PER MM 56-11-11, PRESSURIZED WINDOW AS PER MM 36-00, OPS CHECKED WINDOW HEAT AS PER MM 30-45-02. NO LEAKS NOTED
Back to N283SC, cancelled Dec 3, 2002