N59338, cancelled Mar 21, 2013
Service difficulty reports · 70
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 = 'N59338' AND deregistration_id = 'N59338-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 = 'N59338' AND deregistration_id = 'N59338-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 CALA0100973Channel · corrodedCORROSION ON SUPPORT CHANNEL STATION 995 LBL 13 - 42. REMOVED AND REPLACED HAT SECTION PER SRM 51-10-02.SDR CALA0100972Floor Support · corrodedCABIN LAVATORY WALL FLOOR SUPPORT ANGLE CORRODED AT STATION 995 LBL 13 - 42. REMOVED AND REPLACED L-ANGLE PER SRM 51-10-02.SDR CALA0000278Wire · brokenINSPECTION FOUND SEAT MOUNTED RED EMERGENCY EXIT LIGHT AT ROW 11 INOPERATIVE. MAINTENANCE FOUND A WIRE IN THE SEAT HARNESS BROKEN. THE HARNESS WAS REMOVED AND REPLACED AND OPERATION OF THE LIGHT CHECKED GOOD.SDR CALA9901432Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312, RBL 0 TO RBL 10 AND AT STA 344, RBL 0 TO RBL 2. THE CORRODED SECTIONS OF FLOORBEAM WERE REMOVED AND REPAIRS WERE INSTALLED IAW SRM 53-10-51, FIGURE 205 AND 53-00-51.SDR CALA9901431Window Post · crackedINSPECTION FOUND A 0.37 INCH CRACK IN CAPTAIN'S L-1 WINDOW POST AT AFT UPPER CORNER. THE CRACKED AREA WAS REMOVED AND A REPAIR DOUBLER WAS INSTALLED IAW ECRA 5330-02833.SDR CALA9801391Connector · failedTHE NR 2 AND NR 3 TRANSFORMER RECTIFIER CIRCUIT BREAKERS POPPED ACCOMPANIED BY AN ELECTRICAL SMELL IN THE CABIN DURING CRUISE AT FL 310. THE AIRCRAFT LANDED AT CLE WITHOUT INCIDENT. MAINTENANCE FOUND THE NR 2 GENERATOR D410 FIREWALL CANNON PLUG BURNT. THE DSDR CALA9701504Skin · crackedINSPECTION FOUND A .375 INCH CRACK IN UPPER RT PYLON SKIN AT CUTOUT FOR ACCESS NR 5827. THE SKIN WAS REPAIRED IAW ECRA 5430-01230.SDR CALA9701498Flap · delaminatedINSPECTION FOUND UPPER MOST OUTBOARD END OF LT OUTBOARD MIDFLAP DELAMINATED. THE FLAP WAS REPAIRED IAW SRM 51-70-10, FIGURE 12.SDR CALA9701497Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 294 ON RT SIDE. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED. A NEW SECTION AND DOUBLERS WERE FABRICATED AND INSTALLED IAW SRM 53-10-51.SDR CALA9701496Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 328, RBL 15. A SPLICE REPAIR WAS INSTALLED IAW SRM 53-10-51, FIGURE 205.SDR CALA9701499Flap · delaminatedINSPECTION FOUND LT OUTBOARD AFT FLAP DELAMINATED. THE FLAP WAS REMOVED AND REPLACED.SDR CALA9701442Skin · dentedFORWARD CARGO DOOR HAS DENT 2 BY 3. INSTALLED DOUBLER IN ACCORDANCE WITH SRM 52-00-01.SDR CALA9701441Door · creasedC-1 DOOR UPPER HALF DEEP CREASE JUST FWD OF DOOR CENTER LINE. INSTALLED DOUBLER IN ACCORDANCE WITH SRM 52-00-01.SDR CALA9701440Door · dentedC-1 DOOR 2 DENTS UPPER HALF AND JUST AFT OF DOOR CENTER LINE. INSTALLED DOUBLER IN ACCORDANCE WITH SRM 52-00-01.SDR CALA9701500Foreflap · delaminatedINSPECTION FOUND LEFT OUTBOARD TRAILING EDGE FOREFLAP DELAMINATED ON UPPER SURFACE. THE FOREFLAP WAS REMOVED AND REPLACED.SDR CALA9701401Gcu · inoperativeTHE NR 1 GENERATOR FAILED WHILE EN ROUTE FROM EWR TO ORD. THREE ATTEMPTS TO RESET WERE UNSUCCESSFUL. THE AIRCRAFT WAS DIVERTED TO BUF WHEN ELECTRICAL FUMES AND SMOKE DEVELOPED. THE AIRCRAFT LANDED WITHOUT INCIDENT. THE NR 1 GCU AND THE BATTERY CHARGER WERESDR CAL950929Skin · gougedHOU - INSPECTION FOUND A 0.2 INCH WIDE BY 6 INCH LONG GOUGE IN RUDDER RIGHT SKIN PANEL. THE AREA WAS REPAIRED IAW ECRA 5540-01061 AND SRM 51-70-17, FIGURE 19. (X)SDR CAL950928Skin · crackedHOU - INSPECTION FOUND CRACKS COMING FROM A LINE OF SIX RIVETS ON NR 1 SLAT LOWER SKIN JUST OUTBOARD OF ACTUATOR ATTACH FITTING. TOTAL LENGTH OF CRACKS WAS 5.5 INCHES. A DOUBLER REPAIR WAS FABRICATED AND INSTALLED IAW BOEING DRAWING NR 65C30133 AND ECRA 5750SDR CAL950927Skin · crackedHOU - INSPECTION FOUND CRACKS COMING FROM A LINE OF TWO RIVETS ON NR 6 SLAT LOWER SKIN BETWEEN TAIL DUCT AND ACTUATOR. TOTAL LENGTH OF CRACKS WAS 1.125 INCHES. A DOUBLER REPAIR WAS FABRICATED AND INSTALLED IAW ECRA 5750-01159. (X)SDR CAL950926Skin · crackedHOU - INSPECTION FOUND CRACKS COMING FROM A LINE OF THREE RIVETS ON NR 6 SLAT LOWER SKIN AT INBOARD AUXILIARY TRACK. TOTAL LENGTH OF CRACKS WAS 2.5 INCHES. A DOUBLER WAS FABRICATED AND INSTALLED IAW ECRA 5750-01159. (X)
Back to N59338, cancelled Mar 21, 2013