N14347, cancelled Mar 21, 2013
Service difficulty reports · 80
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 = 'N14347' AND deregistration_id = 'N14347-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 = 'N14347' AND deregistration_id = 'N14347-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 CALA0400094Bulkhead · corrodedINSPECTION FOUND FORWARD SIDE OF AFT PRESSURE BULKHEAD LEFT AND RIGHT OF CENTER STIFFENER (APB DOME WEB) CORRODED AT STA 1016, BL 0. A REPAIR DOUBLER WAS INSTALLED IAW BOEING DRAWING 65C28106.SDR CALA0400093Stiffener · corrodedINSPECTION FOUND FORWARD SIDE LOWER AFT PRESSURE BULKHEAD CENTER CHANNEL STIFFENER CORRODED AT BS 1016-1025, BL 0. STIFFENERS AND SPLICES WERE INSTALLED IAW BOEING DRAWING 65C28106.SDR CALA0400092Stringer · corrodedINSPECTION FOUND STRINGER 25L CORRODED BETWEEN STRINGER END FITTING FORWARD OF STA 1016. A REPAIR WAS INSTALLED IAW SRM 53-00-03, FIGURE 201, PAGE 206.SDR CALA0400089Angle · corrodedINSPECTION FOUND R-1 DOOR CUTOUT ZEE ANGLE CORRODED FROM STA 290-360. THE ZEE ANGLE WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0400088Stringer · crackedINSPECTION FOUND STRINGER 8R CRACKED AT FIVE ADJACENT FASTENERS AT FRAME BS 380. THE CRACKS WERE .75 INCH LONG. A STRINGER PLATE WAS INSTALLED WITH LOCK FASTENERS IAW SRM 51-40-02.SDR CALA0400087Stringer · corrodedINSPECTION FOUND STRINGER 26R CORRODED BETWEEN STA 1006-1016. REPAIRED IAW BOEING DRAWING 65-45776.SDR CALA0400085Intercostal · crackedINSPECTION FOUND A 6 INCH CRACK IN INTERCOSTAL BETWEEN STA 344 AND 360, BL 0. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA0400084Web · crackedINSPECTION FOUND SHEAR WEB PANEL CRACKED IN TWO PLACES AT LT FUSELAGE FORWARD OF STA 639 AT S17L. THE WEB WAS REMOVED AND A NEW WEB WAS INSTALLED IAW SRM 51-40-02.SDR CALA0400083Attach Angle · crackedINSPECTION FOUND A 4 INCH CRACK IN ANGLE ON TOP OF INTERCOSTAL BETWEEN STA 380 AND 400, BL 0. THE ANGLE WAS REMOVED AND REPLACED IAW SRM 53-30-51.SDR CALA0400081Angle · crackedINSPECTION FOUND A 2 INCH CRACK IN AFT CABIN L-ANGLE AT TOP OF INTERCOSTAL WEB AT FASTENER HOLES (4 EACH), STA 927-947, BL 0, WL 209. A SHEAR WEB ANGLE WAS INSTALLED IAW SRM 51-40-02 AND BOEING DRAWING 69-36656.SDR CALA0400077Support · corrodedINSPECTION FOUND L-1 DOOR THRESHOLD SUPPORTS CORRODED. INNER AND OUTER THRESHOLD SUPPORTS WERE INSTALLED IAW SRM 51-40-02.SDR CALA0400076Seat Track · corrodedINSPECTION FOUND FORWARD ENTRY SEAT TRACK CORRODED FROM STA 270-294.5, RBL 40. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-40-02.SDR CALA0400073Support · corrodedINSPECTION FOUND R-1 DOOR THRESHOLD SUPPORTS CORRODED AT STA 300-326. THE SUPPORTS WERE REPLACED IAW SRM 51-10-02.SDR CALA0300457Floorbeam · corrodedINSPECTION FOUND FLOORBEAM FLANGE AT NUTPLATE HOLE CORRODED, FS 947, LBL 5. A REPAIR STRAP WAS INSTALLED SRM 53-00-51, PAGE 213.SDR CALA0300455Frame · corrodedINSPECTION FOUND CHORD CORRODED AROUND NUTPLATE HOLE AT FS 967, LBL 42. AN UPPER CHORD REPAIR WAS INSTALLED IAW SRM 53-00-51.SDR CALA0300454Floorbeam · corrodedINSPECTION FOUND FLOORBEAM NUT PLATE HOLE CORRODED AT FS 967, LBL 28. A REPAIR STRAP WAS INSTALLED IAW SRM 51-21-3.SDR CALA0300453Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 986.5 LT SIDE, AFT OF WATER TANK. A T-CAP WAS INSTALLED IAW ECRA 5310-03851.SDR CALA0300452Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 986.5, RT SIDE. A T-CAP WAS INSTALLED IAW ECRA 5310-03851.SDR CALA0200298Shear Tie · corrodedAFT BILGE AREA CORROSION WHERE ANGLE BRACKETS MEET AFT FACE OF FRAME STATION 986.5 BETTWEEN 27L AND 27R BL0. REMOVED AND REPLACED SHEAR TIE ANGLE PER SRM 51-10-02.SDR CALA2000288SkinFUSELAGE SKIN STA 380-400 HAS 4"X2" DENT WITH OIL CANNING BETWEEN STR 17 & 18. INSTALLED DOUBLER IAW SRM 53-00-01.SDR CALA0000136Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT AFT LAV, STA 986.5. THE FLOORBEAM UPPER CHORD WAS REPLACED IAW ECRA 5310-03851.SDR CALA9800501Sensor · out of adjustTHE LANDING GEAR WOULD NOT RETRACT AFTER TAKEOFF FROM EWR. THE ABNORMAL CHECKLIST WAS COMPLETED AND THE AIRCRAFT WAS RETURNED TO EWR WHERE IT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND THE AIR SAFETY SENSOR OUT OF ADJUSTMENT. THE SENSOR WAS ADJUSTED IAW MM SDR CALA9800471Bleed Lines · looseCABIN PRESSURE WAS LOST WHILE EN ROUTE FROM IAH TO CZM. THE RIGHT PACK OUTPUT WENT TO ZERO. AN EMERGENCY DESCENT WAS PERFORMED AND THE O2 MASKS WERE DEPLOYED. THE AIRCRAFT LANDED AT CZM WITHOUT FURTHER EVENT. MAINTENANCE FOUND HIGH BLEED REGULATOR LINES LOSDR CALA9800223Slat · damagedA CATERING TRUCK STRUCK THE RT OUTBOARD NR 6 SLAT. A REPAIR WAS COMPLETED IAW SRM 57-43-01.SDR CALA9800201Fitting · gougedINSPECTION FOUND THE LT HORIZONTAL STABILIZER AFT LOWER ATTACH FITTING GOUGED IN THREE AREAS ON LOWER SIDE. THE GOUGES WERE BURNISHED, SHOT PEENED, TREATED, AND PRIMED IAW ECRA 5550-01035.SDR CALA9800200Fitting · gougedINSPECTION FOUND RT HORIZONTAL STABILIZER AFT LOWER FITTING OF AFT SPAR GOUGED. THE GOUGE WAS BURNISHED, AND THE AREA WAS SHOT PEENED, TREATED, AND PRIMED IAW ECRA 5550-01035.SDR CAL960308Hyd Pump · leakingFLT NR 784 - IAH - THE 'A HYDRAULIC SYSTEM QUANTITY DROPPED TO ONE FOURTH AFTER DEPARTING ATL. THE NR 1 ENGINE LOW PRESSURE LIGHT FLICKERED ON AND OFF WHILE AT CRUISE. CHECKLIST PROCEDURES WERE COMPLIED WITH AND THE 'A' SYSTEM ENGINE PUMP WAS TURNED OFF. THESDR CAL960248Hyd Line · rupturedFLT NR 778 - IAH - THE 'B' SYSTEM HYDRAULIC QUANTITY DROPPED TO ZERO WHILE IN CRUISE FLIGHT. ALTERNATE FLAPS WERE USED AND THE GROUND PROXIMITY FLAP INHIBIT SWITCH WAS ACTIVATED IAW THE AIRCRAFT FLIGHT MANUAL. THE AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANSDR CAL950862Hinge Cut Out · crackedIAH - INSPECTION FOUND A .1250 INCH CRACK IN UPPER CORNER OF FORWARD GALLEY DOOR HINGE LOWER CUT OUT. THE CUT OUT WAS REPAIRED IAW EA 5210-01055. (X)SDR CAL950861Hinge Cut Out · crackedIAH - INSPECTION FOUND A .25 INCH CRACK IN LOWER CORNER OF FORWARD ENTRY DOOR HINGE LOWER CUT OUT. THE CUT OUT WAS REPAIRED IAW EA 5210-01055. (X)
Back to N14347, cancelled Mar 21, 2013