N63305, cancelled Mar 21, 2013
Service difficulty reports · 111
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 = 'N63305' AND deregistration_id = 'N63305-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 = 'N63305' AND deregistration_id = 'N63305-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 CALA0700356Seat Track · corrodedINSPECTION FOUND LEFT O/B SEAT TRACK CORRODED AT STA 867-947, LBL 40. A NEW SEAT TRACK SECTION WAS INSTALLED IAW SRM 53-00-52, REPAIR 3, FIGURE 201.SDR CALA0700355Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, S17R TO 17L. THE FLOORBEAM WAS REPAIRED IAW ECRA 5310-03851.SDR CALA0700159Skin · crackedINSPECTION FOUND A 2 INCH CRACK IN FUSELAGE SKIN AT STA 727D-727E, S23L (AT LEFT AFT EMERGENCY LIGHT). REPAIRED IAW ECRA 5330-03658.SDR CALA0700158Skin · crackedINSPECTION FOUND A 1.75 INCH CRACK IN FUSELAGE SKIN AT STA 727E-727D, S23R (AT WING AFT EMERGENCY LIGHT). DOUBLERS WERE INSTALLED IAW ECRA 5330-03659, REV A.SDR CALA0600417Skin · crackedFUSELAGE CRACK AT STA 747, 12 INCHES BELOW WATER LINE. REPAIRED IAW SRM 53-00-01 REPAIR 31 FIG 201.SDR CALA0500308Keelbeam · corrodedINSPECTION FOUND RT WHEEL WELL LOWER KEEL BEAM MILDLY CORRODED AT STA 690-727, S28R. REPAIRED IAW ECRA 5311-01237.SDR CALA0500305Shear Tie · corrodedINSPECTION FOUND SHEAR TIE AT STA 847 BETWEEN S27L AND S27R, LBL 6 TO RBL 6 CORRODED. THE CORRODED SECTION OF SHEAR TIE WAS CUT OUT AND A REPAIR DOUBLER WAS INSTALLED IAW SRM 53-00-07, FIGURE 208.SDR CALA0500044Wire Harness · shortedTHE NR 1 ENGINE WAS SLOW TO SPOOL AND THEN FLAMED OUT ON TAXI OUT IN PHL. THE AIRCRAFT WAS RETURNED TO THE GATE. THE DAMAGED WIRES WERE REPLACED. BOEING EXAMINED THE WIRE HARNESS & FOUND THE INSULATION ON THE WIRES DETERIORATED TO THE EXTENT THAT THE WIRE COSDR CALA0400244Skin · crackedINSPECTION FOUND A 2 INCH CRACK IN RIGHT FUSELAGE SKIN AT BS 727E, S18R ABOVE EMERGENCY EXIT LIGHT AT WATERLINE. A REPAIR WAS INSTALLED IAW SRM 53-00-01, FIGURE 202.SDR CALA0300422Support Angle · crackedINSPECTION FOUND A 2 INCHES CRACK IN NR 3 FLAP FAIRING AFT SUPPORT ANGLE THE SUPPORT ANGLE WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA0300403Intercostal · crackedINSPECTION FOUND A 1 INCH CRACK IN FORWARD CARGO PIT INTERCOSTAL AT STA 520, LBL 48. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-10-02SDR CALA0300400Angle · corrodedINSPECTION FOUND R-1 DOOR Z-ANGLE CORRODED. THE Z-ANGLE WAS REMOVED AND A NEW ANGLE WAS INSTALLED IAW SRM 51-10-02.SDR CALA0300397Support · corrodedINSPECTION FOUND RT AFT LAV WALL SUPPORT HAT SECTION CORRODED. THE WALL SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-40-00.SDR CALA0300670Floor Support · corrodedINSPECTION FOUND FLOOR SUPPORT CORRODED ON LOWER SIDE OF FLOOR SUPPORT AT STA 967-986, LBL 17.SDR CALA0300669Beam · crackedINSPECTION FOUND A CRACK AT LOWER FORWARD CORNER OF LOWER BEAM OF L-1 DOOR. A DOUBLER WAS INSTALLED IAW SRM 52-10-02.SDR CALA0300668Strap · crackedINSPECTION FOUND E&E COMPARTMENT CEILING STRAP CRACKED BETWEEN STA 312 AND 328, BL 0. REPAIRED IAW SRM 51-70-13.SDR CALA0300671Support · corrodedINSPECTION FOUND CROSS SUPPORT IN AFT LAV AREA CORRODED BETWEEN STA 1006 AND 1016, RBL 16. A CROSS SUPPORT ANGLE WAS INSTALLED IAW SRM 51-10-02.SDR CALA0300667Support · corrodedINSPECTION FOUND RIGHT AFT LAV WALL SUPPORT CORRODED. THE LAV WALL SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-40-00.SDR CALA0300666Floor Support · corrodedINSPECTION FOUND FLOOR SUPPORT IN RT LAV AREA CORRODED AT STA 986.5-1006, RBL 42. A NEW CHANNEL WAS INSTALLED IAW SRM 51-10-02.SDR CALA0300665Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED IN FORWARD GALLEY AREA AT STA 328, RBL 29. THE CORROSION WAS REMOVED AND A STRAP WAS INSTALLED IAW SRM 53-00-51.SDR CALA0300664Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, RBL 16. REPAIRED IAW SRM 51-10-02.SDR CALA0300663Floorbeam · corrodedINSPECTION FOUND AFT CABIN FLOORBEAM CORRODED AT STA 1006, LBL 15. A STRAP DOUBLER WAS INSTALLED IAW SRM 53-00-51.SDR CALA0300662Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED IN AFT LAV AREA AT STA 1016, RBL 10. INSTALLED REPAIR STRAP IAW SRM 53-00-51, FIGURE 203.SDR CALA0300661Floorbeam · corrodedINSPECTION FOUND AFT CABIN FLOORBEAM CORRODED AT STA 986.5, RBL 46. REPAIRED IAW SRM 53-00-51, FIGURE 203.SDR CALA0300660Skin · dentedINSPECTION FOUND TWO DENTS ON BOTTOM I/B SURFACE OF LEFT AFT NR 2 T/E FLAP. REPAIRED PER SRM 57-53-02, 51-70-10.SDR CALA0300346Indicator · inoperativeSMOKE BEGAN COMING FROM THE F/O'S RMI WHILE EN ROUTE TO ATL. THE APPROPRIATE C/B WAS PULLED AND THE SMOKE CEASED. THE AIRCRAFT LANDED SAFELY AT ATL WITHOUT FURTHER INCIDENT. MAINTENANCE FOUND THE RMI AT FAULT. THE F/O'S RMI/DME(DUAL UNIT) WAS REMOVED AND RSDR CALA0200013Skin Panel · crackedINSPECTION FOUND A 2 INCH CRACK IN RIGHT WING L/E CUTOUT AT O/B AUX TRACK NR 5 SLAT PANEL. REPAIRED IAW SRM 51-70-16.SDR CALA0200012Fitting · crackedINSPECTION FOUND A 1/16" CRACK IN L/H O/B MLG BEAM FITTING. THE FITTING WAS REPLACED IAW TASK CARD 03-5743-1-0003 AND EA 5743-01022.SDR CALA0200011Fitting · crackedINSPECTION FOUND A 1/16" CRACK IN R/H O/B MLG BEAM FITTING. THE FITTING WAS REPLACED IAW TASK CARD 03-5743-1-0002 AND 03-5743-1-0004, SEQ 579, AND EA 5743-01022.SDR CALA0200010Skin · corrodedINSPECTION FOUND FUSELAGE SKIN CORRODED AT STA 520, S28R. A DOUBLER WAS INSTALLED IAW ECRA 5311-01111.SDR CALA0200009Stringer · corrodedINSPECTION FOUND STRINGER S28R CORRODED AT BS 520-540. THE CORROSION WAS REMOVED AND A REPAIR WAS INSTALLED IAW SRM 51-40-00 AND ECRA 5311-01111.SDR CALA0200002Skin · crackedINSPECTION FOUND THE #2 ENGINE PYLON ACCESS PLATE #5824R CUTOUT CRACKED AT FORWARD UPPER AND AFT LOWER AREAS. THE CRACKS WERE 1.6" LONG. A DOUBLER AND ANGLE WERE INSTALLED IAW ECRA 5430-01204.SDR CALA0101041Cap · corrodedINSPECTION FOUND END CAP CORRODED AT STA 540, LONGERON 27R. A NEW END CAP WAS INSTALLED IAW SRM 51-10-2.SDR CALA0101039Skin · crackedINSPECTION FOUND A 1 INCH CRACK ABOVE NR 3 SLAT ACTUATOR IN LT WING LEADING EDGE CUTOUT. THE LEADING EDGE WAS REPAIRED IAW MM 51-70-17.SDR CALA0101037Skin · crackedINSPECTION FOUND A .75 INCH CRACK IN LT ENGINE UPPER PYLON SKIN AT PANEL CUTOUT 5727L. A REPAIR DOUBLER WAS INSTALLED IAW ECRA 5430-01230, REV B.SDR CALA0101036Beam · corrodedINSPECTION FOUND LT MLG ACTUATOR WALKING BEAM HANGER AND BRACKET HARDWARE CORRODED. A NEW WALKING BEAM HANGER AND BRACKET HARDWARE WERE INSTALLED IAW MM 57-15-00.SDR CALA0101034Skin · crackedINSPECTION FOUND A 1/4" CRACK IN R/H WING #6 SLAT PANEL SKIN. REPAIRED IAW SRM 57-43-01.SDR CALA0101029Floor Support · crackedINSPECTION FOUND A .5 INCH CRACK IN FLOOR SUPPORT AT STA 500-500A, L27R. REPAIRED IAW SRM 51-70-11.SDR CALA0101028Frame · corrodedINSPECTION FOUND FRAME CORRODED AT STA 500, L27R. REPAIRED IAW SRM 51-70-11.SDR CALA0100601Door · crackedINSPECTION FOUND TWO 4.5" CRACKS IN FORWARD CARGO DOOR AT LOWER AFT CORNER. THE FORWARD CARGO DOOR WAS REMOVED AND REPLACED IAW MM 52-31-00.SDR CALA0001601Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT R-2 GIRT BAR MOUNT STA 986.5, RBL 40. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND REPLACED IAW ECRA 5310-03851 AND SRM 53-60-51.SDR CALA9901046Stringer · crackedINSPECTION FOUND A 1 INCH CRACK IN STRINGER 16L AT STA 390. A DOUBLER REPAIR WAS INSTALLED IAW SRM 53-00-03.SDR CALA9901045Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT STA 344, RBL 10 TO LBL 50. REPAIRED FLOORBEAM IAW SRM 53-10-51.SDR CALA9901044Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT STA 328, LBL 15 TO RBL 50. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51.SDR CALA9901040Stringer · crackedINSPECTION FOUND A 1 INCH CRACK IN STRINGER 16R AT BS 500C. REPAIRED IAW SRM 53-00-03.SDR CALA9901080Blkhd Stiffener · corrodedINSPECTION FOUND BOTTOM CENTER RT STIFFENER CORRODED AT AFT PRESSURE BULKHEAD SIDE. REPAIRED IAW SRM 51-70-11, FIGURE 1.SDR CALA9901038Angle · corrodedINSPECTION FOUND Z-ANGLE CORRODED AT R-2 DOOR. THE Z-ANGLE WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA9901037Channel · corrodedINSPECTION FOUND L-1 DOOR THRESHOLD Z-CHANNEL CORRODED. THE Z-CHANNEL WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA9901009Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CAP CORRODED AROUND NUT PLATE HOLES AT STA 947.5, LBL 15 TO RBL 8. THE FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 53-00-51, PAGE 207-209.SDR CALA9901008Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312, LBL 10 TO RBL 25. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51.
Back to N63305, cancelled Mar 21, 2013