N965DN, cancelled May 4, 2020
Service difficulty reports · 67
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 = 'N965DN' AND deregistration_id = 'N965DN-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 = 'N965DN' AND deregistration_id = 'N965DN-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 DALA2018070304347Slide · unserviceableFOUND L1 SLIDE PACK RETAINING PINS HAD FALLEN OUT OF EYELETS. R&R SLIDE PACK ON L1 DOOR PER AMM 25-61 AND W/C 2561-4641 A/C OK FOR SVC.SDR DALA2018051503145Wire · brokenDURING A LINE CHECK, FOUND THE EMERGENCY LIGHT INOPERATIVE ABOVE THE TAIL CATWALK. REPAIRED A BROKEN WIRE. OK FOR SERVICE .SDR DALA2018031401704Light · inoperativeLEFT CEILING EMERGENCY EXIT LIGHT AT ROW 17 INOPERATIVE. REPLACED THE LIGHT ASSEMBLY. OPS NORMAL, OK FOR SERVICE.SDR DALA2018013000581Battery Pack · dischargedAFT AIRSTAIRS EMERGENCY LIGHT INOPERATIVE. REMOVED AND INSTALLED BATTERY PACK. OPERATION CHECKS GOOD.SDR DALA2017090306660Hinge · damagedDURING A TAILCONE DEPLOYMENT TEST FROM THE BULKHEAD DOOR, THE DECORATIVE COVER PREVENTED THE SLIDE DEPLOYMENT. REPLACED HINGE AND INSTALLED DECORATIVE COVER.SDR DALA2017081106139Wire · burnedWITH ANTI-FOG SWITCH ON, GET AN ELECTRICAL ODOR IN COCKPIT. NO CIRCUIT BREAKERS OPEN, TURN SWITCH OFF, ODOR DISAPPEARS. TROUBLESHOT AND FOUND THE SLIDING F/O WINDOW ANTI-FOG WIRING SPLICES NOT MAKING GOOD CONTACT AND BURNING. REPAIRED THE WIRING IAW SWPM 20.SDR DALA2017072105622Lanyard · disconnectedL1 SLIDE LANYARD DISCONNECTED AND DANGLING. REINSTALLED. OPERATION CHECKS OK.SDR DALA2017070205152Sign · unsecureFLIGHT ATTENDANT REPORTS EXIT SIGNS FALLING OFF AT LOCATION 608-104. REATTACHED SIGNS AND SECURE IAW MM.SDR DALA2017052304162Sign · missingR1 EMERGENCY EXIT SIGN MISSING. REPLACED. OPERATION CHECKED GOOD.SDR DALA2017032102391Hook And Loop · failedEMERGENCY EXIT SIGN COVER LOOSE. REPLACED THE HOOK AND LOOP. CHECKED OK.SDR DALA2017013100924Sign · looseEMERGENCY EXIT SIGN LOOSE. REATTACHED SIGN. OK FOR SERVICE.SDR DALA2016102007434Skin · dentedDENT ON EXTERIOR OF L1 DOOR BOTTOM LEFT SIDE. REPAIRED IAW SRM 52-01-01.SDR DALA2016082106227Support Angle · brokenFOUND TWO SUPPORT ANGLES BROKEN, UNDER UPPER WING TO FUSELAGE FAIRING. REPLACED CENTER SUPPORT IAW DWG 9951259.SDR DALA2016080905951Frame · crackedFORWARD FLANGE CRACKED, BS 1508. REPLACED FRAME SECTION IAW DWG 9911860.SDR DALA2016080605904Doubler · crackedAIRCRAFT SKIN DOUBLER CRACKED, 10 LBL, BS 1520, UPPER CHORD. REPAIRED IAW PRI/ERA 549409-14.SDR DALA2016080105810Threshold · damagedR1 DOOR THRESHOLD WEB HAS HOLE IN IT, BS 173, RBL 54. REPLACED THE THRESHOLD IAW SRM 51-00-00.SDR DALA2016080105809Threshold · damagedR1 DOOR THRESHOLD WEB HAD HOLE IN IT, BS 196, RBL 54. REPLACED THRESHOLD WEB IAW SRM 51-00-01.SDR DALA2016080105753Floor Support · corrodedFLOOR SUPPORT CORRODED, BS 218, LBL 1. REMOVED AND REPLACED FLOOR SUPPORT IAW SRM 51-00-00.SDR DALA2016080105752Floor Support · corrodedFLOOR SUPPORT CORRODED BS 200, LBL 7. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-00-01.SDR DALA2016080105751Floor Support · corrodedFLOOR SUPPORT CORRODED BS 200, RBL 7. REMOVED AND REPLACED FLOOR SUPPORT IAW SRM 51-00-00.SDR DALA2016080105750Seat Track · corrodedCORROSION FOUND AT INBOARD SEAT TRACK UNDER G2 GALLEY. REMOVED AND REPLACED THE SEAT TRACK IAW SRM 53-40-01.SDR DALA2016080505812Seat Track · corrodedSEAT TRACK, RBL 46, BS 200 CORRODED. REPLACED THE SEAT TRACK IAW SRM 53-40-01.SDR DALA2016080505811Floor Panel · corrodedFLOOR PANEL CORRODED, BS 200, RBL 9 - 46. REMOVED AND REPLACED THE FLOOR PANEL IAW DWG 9936534.SDR DALA2016080405779Web · corrodedG2 GALLEY WEB CORRODED, BS 218, RBL 11. REPAIRED IAW SRM 53-00-01.SDR DALA2016080405778Floor Support · corrodedFLOOR SUPPORT CORRODED, BS 178-198 RBL 43. REPAIRED IAW SRM 51-00-00.SDR DALA2016080405777Floorbeam · corrodedFLOORBEAM CORRODED, BS 200, RBL 46-56. REPLACED IAW SRM 53-00-01.SDR DALA2016080405776Floorbeam · corrodedFLOORBEAM CORRODED, BS 200, RBL 5- LBL 5. REPLACED IAW SRM 53-00-01.SDR DALA2016072705616Skin · crackedCAPTAIN'S SLIDING WINDOW CUTOUT CRACKED. REPLACED IAW DWG 591365.SDR DALA2015051903351Support · crackedSLANT SUPPORTS CRACKED, BS 750 ABOVE LONGERON 27L. FABRICATED AND INSTALLED IAW SRM 412247-14MA AND SRM 51-30-02.SDR DALA2014082704779Flange · bentL1 DOOR BOTTOM FLANGE BENT. STRAIGHTENED DOOR FLANGE IAW SRM 52-01-01. DOOR OPERATES NORMAL AT THIS TIME.SDR DALA2014081804589Skin · corrodedACFT SKIN HAS STRIP OF LIGHT CORROSION BETWEEN L28R AND SEAL DEPRESSOR AT APPROXIMATELY BS 1234. FOUND TWO AREAS BEYOND LIMITS. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-60-02, FIG 9.SDR DALA2014081504543Channel · crackedLEFT WHEEL WELL FORWARD CUTOUT WAS CRACKED UNDER HYDRAULIC SUPPORT BRACKET. REPLACED CHANNEL IAW SRM 51-30-02 AND DWG 5930584.SDR DALA2014081404534Fastener · looseVERTICAL STABILIZER, ZFS-52.267, NUMEROUS LOOSE FASTENERS ON LOWER SIDE OF SPLICE, AMDS 5530-01044-05.SDR DALA2014081404538Lanyard · missingSLIDE FOUND WITH MANUAL INFLATION LANYARD NOT INSTALLED. INSTALLED SLIDE IAW AMDS 2561-4641.SDR DALA2014081204417Pin · migratedPIN MIGRATED FROM RECEPTACLE ON R1 SERVICE DOOR SLIDE. R & R SLIDE IAW AMDS 2551-4641.SDR DALA2014063003836Battery Pack · inoperativeCAT WALK FLOOR ILLUMINATION EMERGENCY LIGHTS INOPERATIVE. R & R BATTERY PACK IAW AMM. OPS CHECKED GOOD.SDR DALA13070219265Wedge · damagedLEFT INBD T/E FLAP WEDGE DAMAGED. FABRICATED AND INSTALLED NEW REPAIR DOUBLER IAW SRM 57-00-01.SDR DALA13070209265Wedge · damagedLEFT INBD T/E FLAP WEDGE DAMAGED. REPAIRED IAW ERA 509956-14MA, REV O.SDR DALA13069059265Skin · damagedLEFT INBD LOWER SKIN AND T/E WEDGE AFT LT FLAP DAMAGED. FABRICATED AND INSTALLED REPAIR IAW PRI 521487-14, REV O.SDR DALA12012619265Unknown · smokeCREW SMELLED SMOKE AND SAW A WISP OF SMOKE BY CAUTION LIGHTS. MX COMPLIED WITH LIGHTNING STRIKE INSPECTION IAW AMM. CAUTION LIGHTS CHECK NORMAL. NO EVIDENCE OF OVERHEAT OR DAMAGE OF WIRING BEHIND CAUTION LIGHTS.SDR DALA1245189265Tee Fitting · corrodedAFT ACCESSORY COMPARTMENT BILGE AREA HAS CORROSION AT FS 1437 LBL 16 INCHES RBL16 INCHES BELOW THE CROSSOVER DUCT. REMOVED AND REPLACED LOWER TEE FRAME AT FS 1437 P/N 9912246U115.SDR DALA1244199265Support · crackedFWD AIRSTAIR CUT OUT LOWER CENTER AREA BEHIND SEAL RETAINER IS BENT AND POSSIBLE CRACK AT FASTENER HOLE. REPAIRED PER ERA 501336-14 REV O.SDR DALA1244189265Angle · corrodedAFT FUSELAGE APU CUT OUT LT TEE ANGLE WITH HEAVY CORROSION AT SEVERAL NUTPLATE LOCATIONS. REMOVED AND REPLACED TEE ANGLE PER SRM 51-30-02 VOL II AND 51-30-05 VOL II.SDR DALA1242269265Intercostal · corrodedAFT ACCESSORY COMPARTMENT BILGE AREA INTERCOSTAL AT BS 1438 RBL 13 HAS EXFOLIATION CORROSION. REMOVED AND REPLACED INTERCOSTAL WITH FABRICATED INTERCOSTAL PER MD90 SRM 51-30-02 VOL II, 51-10-02 VOL II, AND DWG 9915563.SDR DALA1242249265Frame · corrodedFUSELAGE SKIN HAS BULGE SUSPECTED CORROSION AT BS 455 L30 ABOUT 3 INCHES FROM VHF ANTENNA. REPAIRED PER ERA 503597-14. CUT SECTION OF FRAME STA 465 AT L26L TO L27L FOR ACCESS AND REPAIRED FRAME PER SRM 53-10-02 FIG 2 P 17 VOL I.SDR DALA1244209265Shear Tie · crackedNR 1 PYLON FRONT SPAR FWD END BETWEEN L15L AND L16L AT BS 1364 SHEAR TIE HAS CRACK AS VIEWED FROM CABIN. REMOVED AND REPLACED SHEAR TIE PER SRM 51-30-05 VOL II.SDR DALA1242239265Longeron · corrodedMID CARGO COMPARTMENT LONGERON 29R HAS CORROSION ON TOP OF LOWER FLANGE BS 769. REPAIRED PER ERA 503603-14.SDR DALA1242219265Frame · corrodedMID CARGO COMPARTMENT UPPER SURFACE LOWER FLANGE ON FRAME AT BS 750 OTBD OF LONGERON 28R, HAS CORROSION AT TIP AREA AROUND FASTENER. REPAIRED PER ERA 503602-14.SDR DALA1242209265Doubler · corrodedCENTER CARGO COMPTARTMENT BETWEEN BS 807-826 AND BETWEEN L29 - 30R SKIN HAS CORROSION. REPAIRED PER ERA 503600-14.SDR DALA1242199265Finger Doubler · damagedLT ALTERNATE STATIC PORT SEMI-CRITICAL AREA HAS DEPRESSION NEXT TO RIVET FS 459 LONGERON 26L. REPAIRED PER ERA 503594-14.
Back to N965DN, cancelled May 4, 2020