N957DN, cancelled May 4, 2020
Service difficulty reports · 49
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 = 'N957DN' AND deregistration_id = 'N957DN-2020-05-04' 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 = 'N957DN' AND deregistration_id = 'N957DN-2020-05-04' 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 DALA2016102707789Lens · damagedEMERGENCY LIGHT LENS DAMAGED. REPAIRED.SDR DALA2016062905131Slide · damagedL1 DOOR SLIDE UNLACED. REMOVED AND REPLACED L1 DOOR SLIDE.SDR DALA2016060604495Outflow Valve · malfunctionedAUTO 1 AND 2 PRESSURIZATION FAILED IN FLIGHT. MAINTENANCE TROUBLESHOT SYSTEM AND FOUND AUTO 1 AND 2 INOPERATIVE. R & R OUTFLOW ACTUATOR IAW MM. OPERATION CHECKS GOOD.SDR DALA2016041803161Turbine Case · crackedLEFT ENGINE AFT VIBRATOR ISOLATOR THERMAL OVERHEATING FROM CRACK IN TURBINE CASE. R & R AFT VIBRATIONS ISOLATOR IAW MM.SDR DALA2016041402922Frame · wornOVERWING FRAME, BS 883 RT HAS WEAR ON UPPER RADIUS OF THE FRAME TAB FROM THE CUSP WEB. REPAIRED IAW ERA 545329-14AD, REV O.SDR DALA2016041402921Frame · wornOVERWING FRAME, BS 883 LT HAS WEAR ON UPPER RADIUS OF THE FRAME TAB FROM THE CUSP WEB. REPAIRED IAW ERA 545329-14AD.SDR DALA2016041002846Mount · crackedFORWARD LAV AFT MOUNT FLOOR FITTING CORRODED AND CRACKED. FABRICATED AND INSTALLED FITTING IAW DWG.SDR DALA2016041102847Longeron · crackedTAIL INTERIOR LONGERON L3R CRACKED, BS 1494. REPAIRED IAW SRM 53-10-01.SDR DALA2016040902845Longeron · crackedLONGERON 2L CRACKED AT BS 1475. REPAIRED IAW PRI/ERA 545446-14, REV O.SDR DALA2016040802844Skin · crackedFUSELAGE EXTERIOR SKIN CRACKED AT 3 LOCATIONS, BS 1483 AND BS 1481 BETWEEN L2R AND L4R RT SIDE. COMPLIED WITH ERA 545389-14, REV O.SDR DALA2016040802843Fitting · corrodedG2 AFT INBD FITTING CORRODED. REPAIRED IAW DWG C712071.SDR DALA2016040602842Floorbeam · corrodedCORROSION ON CABIL FLOORBEAM , BS 160, BETWEEN RBL 10-20. REPLACED SUPPORT IN NRC 367.SDR DALA2016040602841Floor Support · corrodedCORROSION ON FLOOR SUPPORT, BS 177 TO 181. REPLACED IAW DWG 9936534.SDR DALA2016040602840Floor Support · corrodedCORROSION ON FLOOR SUPPORT, BS 160. REPLACED IAW DWG 9936534.SDR DALA2016040602839Floor Support · corrodedCORROSION ON FLOOR SUPPORT, BS 180. REPLACED IAW DWG 9936534.SDR DALA2016040602838Floor Support · corrodedCORROSION ON FLOOR SUPPORT, BS 200. REPLACED IAW DWG 9936534.SDR DALA2016040602837Cusp Web · corrodedCORROSION ON CUSP WEB, BS 180-190, RBL 46. REMOVED CORROSION. REPAIRED IAW SRM 53-00-01.SDR DALA2016040602836Floor Support · corrodedCORROSION ON FLOOR SUPPORT, BS 200. REPLACED IAW DWG 9936534.SDR DALA2016040602835Floor Support · corrodedCORROSION ON FLOOR SUPPORT, BS 200. OUT OF LIMITS. REPLACED IAW DWG 9936534.SDR DALA2016040602834Floorboard · corrodedCORROSION ON FLOORBOARD WEB AT BS 195. REPAIRED IAW SRM 51-11-01.SDR DALA2016040602723Web · corrodedCORROSION ON FLOOR WEB, BS 196-200. REPAIRED IAW SRM 51-11-01.SDR DALA2016040602722Web · corrodedCORROSION ON FLOOR WEB, BS 192. REPAIRED IAW SRM 53-20-02 AND 51-11-01.SDR DALA2016040602721Web · corrodedCORROSION ON FLOOR WEB, BS 200.5. REPAIRED IAW SRM 51-11-01.SDR DALA2016040602720Fitting · corrodedCORROSION ON R1 DOOR AFT GIRT BAR FITTING. R & R FITTING IAW SRM 51-00-01.SDR DALA2016040602719Floor Support · corrodedCORROSION UNDER G7 GALLEY AND FORWARD LAVATORY FLOOR SUPPORTS, BS 200-BS 218, LBL 18. REPAIRED IAW SRM 53-00-01 AND DWG 9936534 AND 9936535.SDR DALA2016040602718Frame · crackedCRACK FOUND ON FORWARD SIDE OF FRAME TAB, VERIFIED WITH HFEC. REPAIRED FRAME, STA 902.SDR DALA2016033002636Structure · crackedRIGHT WING LOWER L/E CRACKED AT OTBD FWD CORNER OF FUELING BAY. REPAIRED IAW SRM 57-20-01.SDR DALA2016033002635Bulkhead · crackedTAIL INTERIOR CANTED BULKHEAD STA 1520, FORWARD AND AFT WEB IS CRACKED RT SIDE. REPAIRED IAW SRM 53-10-03, PARA 10A.SDR DALA2016032602419Bulkhead · crackedCANTED BULKHEAD, BS 1520, AFT WEB IS CRACKED LT SIDE. ACCESS INSIDE LT VENT BOX. REPAIRED BULKHEAD IAW SRM 51-10-03, FIG 9C.SDR DALA2014102905827Latch · wornLEFT UPPER TAILCONE LATCH WORN. R & R LATCH ASSEMBLY.SDR DALA14032699257Frame · chafedFOUND CHAFING DAMAGE ON FRAME WEB AT BS 1437, L4L. COMPLIED WITH ERA 526153-14, REV O.SDR DALA14032689257Skin · crackedLEFT LOWER AFT FUSELAGE, BS 1531, SKIN CRACKED, AT RIVET ABOVE VENTRAL STAIR CUTOUT. REMOVED DAMAGE. COMPLETED REPAIR IAW SRM 53-00-01, FIG 6.SDR DALA14032679257Skin · crackedSKIN HAS A CRACK THROUGH 2 SIDE OF FASTENER HOLE, BS 1475, L2R. REPAIRED FUSELAGE AND INSTALLED DOUBLER IAW ERA 526106-14, REV O.SDR DALA12014079257Coffeemaker · contaminatedFLIGHT CREW REPORTED A BURNING ODOR FROM COFFEEMAKERS BY THE L1 DOOR. COFFEEMAKERS TURNED OFF. ODOR DISSIPATED. MX FOUND PLASTIC CUP RESIDUE ON LOWER COFFEE DISPENSER HOT PLATE. CLEANED DEBRIS AND ALL RESIDUE. OPS CHECKS GOOD. ALL NORMAL.SDR DALA13037239257Cable · wornVENTRAL STAIRWAY MOVEABLE CEILING CABLE AND SPRINGS WORN. R & R LEFT LIFT CABLE AND SPRING IAW MM. OPS CHECKED GOOD.SDR DALA1235989257Longeron · corrodedAFT CARGO COMPARTMENT AREA, LONGERON 30 HAS EXFOLIATED CORROSION AT STA 1259 LT AND RT. REPAIRED PER ERA 502682-14 REV O.SDR DALA1235959257Skin · crackedR1 DOOR CUT OUT LOWER CORNER EXTERNAL SKIN HAS EDGE CRACKED. REPAIRED PER ERA 501348-14 REV O.SDR DALA1222869257Floorbeam · corrodedMID CARGO FLOORBEAM HAS CORROSION STA 693 L28R TO L28L. REPLACED PER SRM 51-30-05.SDR DALA1222849257Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM STA 1307 LBL 4.5 AND LBL 9.5. FABRICATED FLOORBEAM PER DWG S2929169 AND INSTALLED PER SRM 51-30-05.SDR DALA1222019257Doubler · corrodedAFT PRESSURE DOME LOWER BL 0 TRIANGLE SHAPED DOUBLER CORRODED. REMOVED TEE ANGLE AND DOUBLER. DOUBLER CORRODED OUT OF LIMITS. INSTALLED NEW DOUBLER AND INSTALLED TEE ANGLE PER SRM 53-10-03 VOL I.SDR DALA1222839257Seat Track · corrodedSEAT TRACK GOUGED AND CORRODED STA 1156 LBL 22. REPLACE SEAT TRACK AND INSTALLED SPLICE REPAIR PER SRM 53-40-01.SDR DALA1235979257Seat Track · corrodedFOUND CORROSION ON SEAT TRACK RBL 44.5 BS 234. REMOVED AND REPLACED SEAT TRACK PER SRM 51-40-01 FIG 4 AND FIG 6.SDR DALA1233709257Seat Track · damagedFOUND CABIN SEAT TRACK SCRATCHED LBL44.5 STA 1231 TO 1146. REPLACED TRACK PER SRM 53-40-01.SDR DALA1220319257Cusp Web · corrodedRT CUSP WEB FROM BS 674 TO 750 SEVERAL AREAS WITH SURFACE CORROSION. REMOVED CORROSION, OIL CANNING AND OUT OF LIMITS. REPAIRED AREAS PER SRM 53-20-02 VOL I AND 53-30-02 VOL II.SDR DALA1235949257Angle · crackedEMPENNAGE RT SIDE AT STRINGER 16 ON CANTED 1520.225 THERE IS A CRACK IN THE RADIUS. REMOVED ANGLE AND REPLACED PER MD90 SRM 51-30-05 VOL II, 51-30-02 VOL II, AND 51-20-00 VOL II.SDR DALA1233699257Support Fitting · unknownINSPECTED RT MLG RETRACT ACTUATOR SUPPORT FITTING. REPLACED FITTING, BUSHING, AND BEARING.SDR DALA1222829257Longeron · corrodedMID CARGO HAS CORROSION SPOT ON 4EA. STRAPS LONGERON 28R AND 30 STA 758-769. FABRICATED STRAPS PER DWG 9936578 AND 5936071. INSTALLED PER MD 90 SRM 51-10-05 AND 51-30-05.SDR DALA1235939257Floor Support · corrodedAFT CARGO COMPT BETWEEN STA 1212 AND 1269 FLOOR SUPPORT WITH CORROSION. REMOVED AND REPLACED FLOOR SUPPORT PER MD90 SRM 51-10-05 VOL. II.SDR DALA1235929257Longeron · corrodedMIS CARGO COMPARTMENT DOOR JAMB BETWEEN STA 693-750 WITH HEAVY CORROSION. REMOVED AND REPLACED LONGERON 28R FROM STA 655 - 788 PER SRM 51-30-05 AND DRAWING 5930481.
Back to N957DN, cancelled May 4, 2020