N784DA, cancelled Jun 14, 2001
Service difficulty reports · 104
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 = 'N784DA' AND deregistration_id = 'N784DA-2001-06-14' 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 = 'N784DA' AND deregistration_id = 'N784DA-2001-06-14' 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 DLL13980792Power Supply · inoperativeL1 DOOR EMERGENCY LIGHTS INOP. REPLACED POWER SUPPLY.SDR DLL13980286Rear Spar · crackedDURING INSPECTIONS, SEVERAL HOLES IN THE LT AND RT WING REAR SPAR UPPER CAP WERE FOUND CRACKED IN THE SKIN-TO-CAP AND CAP-TO-WEB HOLES. THE HOLES WERE OVERSIZED, COLD-WORKED, AND BUSHED. REPAIR DOUBLERS WERE INSTALLED ON THE CAP, SKIN AND WEB PER ER/A 36378SDR DLL13972676Inverter · failedLWR GALLEY EMERG LIGHTS INOP. REPLACED INVERTER MODULE ON BACK OF BATTERY PACK, CKS OK.SDR DLL13971812Bleed Valve · malfunctionedFIRE WARNING BOTH LOOPS, NR 1 ENG. REPLACED BLEED VALVE CKS GOOD.SDR DLL13962478Spar Cap · crackedA FASTENER WAS FOUND CRACKED IN THE LT LOWER SPAR CAP AND SKIN. IT AND THE ADJACENT FASTENER HOLE WERE O/S. THE HOLES WERE COLD-WORKED AND INSTALLED WITH HI-LOKS.SDR DLL13961707Prox Logic Box · failedALL WARNING LIGHTS FAILED AS PREVIOUS LOG BOOK ENTRY, LDG GEAR, SLAT REV PRESS AND INTRANSIT LIGHTS, DOOR OPEN LIGHTS. AIR TURNBACK TO SEA, NO GREEN DOWN AND LOCK LIGHT GEAR.SDR DLL13960525Actuator · inoperative2L DOOR ELECTRIC ACTUATION INOPERATIVE. UNABLE TO CLOSE DOOR MANUALLY. REPLACED 2L DOOR ACTUATOR ASSEMBLY, OPERATION NORMAL.SDR DLL13954801Fitting · brokenLEFT INBOARD AILERON POSITION INDICATOR ON SPI IS STUCK IN FULL DOWN POSITION. REPLACED LEFT INBD AILERON POSITION TRANSMITTER. ALSO, FOUND LEFT O/B ACTUATOR ATTACH FITTING HAD BROKEN LOOSE FROM AILERON. REPLACED AILERON AND ROUTED TO SHOP.SDR DLL13954242Brakes · seizedAFTER START BRAKES REMAINED LOCKED, ALTHOUGH HANDLE RELEASED AND LIGHT WENT OUT. FOUND NR 3 FRONT BRAKE ASSY FROZEN ON AXLE. REPLACED RT FWD MAIN GEAR AXLE, BRAKE AND WHEEL ASSY. WHEEL BEARING FAILED, DAMAGED AND CUT INTO AXLE.SDR DLL13953599Eel Power Pack · failedDURING LAYOVER, L-4 DOOR EMERGENCY LIGHT POWER SUPPLY POPS C/B. REPLACED POWER SUPPLY AND OPERATION NORMAL.SDR DLL13953648Fitting · crackedCOMPLYING WITH INSPECTION SI 7-66332-12 AND AD T95-18-52, FOUND STRINGER TO AFT P-DOME SPLICE FITTING CRACKED AT STRINGER NR 11. SCHEDULED THE FITTING REPLACEMENT PER DL ERA 271759-14.SDR DLL13953585Eel Power Supply · inopL4 DOOR EMERGENCY LIGHT INOP. REPLACED EMER LIGHT BATT PACK, DAL P/N 337001090 SN NR 54051.SDR DLL13954200Blkhd Fittings · crackedDURING THE ACCOMPLISHMENT OF AN INSPECTION OF THE AFT PRESSURE BULKHEAD STRINGER SPLICE FITTINGS PER SI 7-66332-12, THE STR 11 FITTING WAS FOUND TO HAVE CRACKS, IT IS 7075-T6 FORGED AL. ACCOMPLISHED REPAIRS PER DL ERA 271759-14AD.SDR DLL13952858Skin · crackedAT HMV, INTERFACE BOX CRACKED, NR 3 PYLON FWD END. REPAIRED PER SRM 54-11-00 PG 812.SDR DLL13952784Floorbeam · corrodedAT HMV, C-2 CARGO COMPT FLOORBEAM FS 1525 FOUND CORRODED AT LBL 3. REPAIRED PER SRM 53-23-00 PG 803.SDR DLL13952780Floorbeam · corrodedAT HMV, C-2 CARGO COMPT FLOORBEAM FS 1480 LBL 60 CORRODED. REMOVE CAP SECTION, FAB NEW CAP PER SRM 53-23-00 FIG 802 PG 803/804.SDR DLL13952779Floorbeam · corrodedAT HMV, FOUND FLOORBEAM CORRODED AT FS 1525, RIGHT SIDE. REMOVED SECTION OF FLOORBEAM AT STA 1523 RT SIDE. FAB REPAIR PARTS REF SRM 53-23-00 FIG 802.SDR DLL13953240Rear Spar · crackedWHILE ACCOMPLISHING EO 7-59040-3 STRUCTURAL MODIFICATION TO THE REAR SPAR JOINT AT THE BL 115 WING ROOT RIBS, CRACKS WERE FOUND IN THE CENTERWING REAR SPAR WEB TO BL 115 RIB WEB ATTACH ANGLE EMANATING FROM EXISTING ATTACHMENT HOLES. THE CRACKING IS PRESENT ONSDR DLL13952688Skin · corrodedTHE AFT BELLY SKIN WAS FOUND CORRODED AND HAD SEVERAL PREVIOUS REPAIRS REQUIRING REPLACEMENT OF THE BELLY SKIN AT FS 1453 TO 1815, DAMAGE FOUND AT HMV. REPAIRS ACCOMPLISHED PER DL ERA 270891AD.SDR DLL13952658Skin · crackedTHE O/B L/E UPPER SIDE PANEL WAS FOUND TO BE CRACKED. REPAIRED PER SRM 55-22-00, AT HMV FOR RIGHT ELEVATOR.SDR DLL13952662Support · crackedAT HMV, FOUND SUPPORT CRACKED C2 B/B LBL 8.5 AND RBL 8.5. DYE PENETRANT, INSPECTED CRACKS AND STOP DRILLED BOTH CRACKS. FABRICATED NEW ANGLES, DRILLED NEW ANGLES, TREAT AND PAINTED, AND INSTALLED NEW ANGLES PER SRM 53-24-00 PG 807 FIG 805.SDR DLL13952607Doubler · tornAT HMV, FOUND INTERNAL DOUBLER FOR FUS TORN AT STA 1490 BETWEEN STR 27 TO 28, C2 B/B. REMOVED DAMAGE INSTALLED DOUBLER PER SRM 53-31-00.SDR DLL13952666Floor Support · corrodedAT HMV, FOUND FLOOR SUPPORT CORRODED, C1 B/B AT FS 69. REMOVED SUPPORT, DRILLED TREAT AND PAINTED, INSTALLED PER SRM 53-23-00 FIG 802.SDR DLL13952665Floor Support · corrodedAT HMV, FOUND FLOOR SUPPORT CORRODED FS 649 O/B. REMOVED FLOOR SUPPORT, DRILLED NEW FLOOR SUPPORT AND SPLICE ANGLE, INSTALLED PER SRM 53-23-00 FIG 802.SDR DLL13952606Tear Strap · disbondedAT HMV, FOUND TEAR STRAP DISBONDED, AFT CORNER LOWER GALLEY AREA BETWEEN FS 769 TO 789 STA 38. CORROSION REMOVED, PER SRM 51-21-01, FOUND TO BE WITHIN LIMITS PER SRM 53-31-00 FIG 801. MFG AND INSTALLED DOUBLER PER SRM 53-31-00 FIG 804.SDR DLL13952659Skin · crackedTHE T/E TIP SKIN WAS FOUND TO BE CRACKED ON THE LOWER SIDE. THIS WAS REPAIRED PER SRM 55-22-00 FIG 802, AT HMV FOR RT ELEVATOR.SDR DLL13952744Track · corrodedAT HMV, FOUND CABIN SEAT TRACKS WITH CORROSION DAMAGE AT FS 1445 TO 1545. REPLACED TRACK PER SRM 53-23-00.SDR DLL13952679Seat Track · corrodedAT HMV, FOUND SEAT TRACK CORRODED STA 1443 TO 1545. REMOVED SEAT TRACK AND INSTALLED NEW TRACK PER SRM 53-21-00 PG 836.SDR DLL13952366Anti-Ice Duct · crackedNR 2 ENG INLET AT 5:30 O'CLOCK POS. ANTI-ICE DUCT SKIN CRACKED AROUND RIVET. ACCESS THRU PANEL 311 GR-MARKED, REF NR 712. REMOVED DAMAGED AREA. FABRICATED DOUBLER SPACERS AND SHIMS PER SRM 54-34-00 FIG 804.SDR DLL13954210Rib · corrosionDURING THE COMPLETION OF EO 7-56199-3AD, THE RT IWS 346 MLG ATTACH RIB UPPER I/B 1.125 HOLE WAS FOUND WITH CORROSION IN THE HOLE BORE. REPAIRED PER DL ERA 270991-14AD.SDR DLL13952258Seat Track · corrodedAT OVERHAUL THE SEAT TRACK AT STA 649-749, 1ST TRACK TO LEFT OF CENTER, WAS FOUND CORRODED. REPLACED SEAT TRACK PER SRM 5321-00 PG 836.SDR DLL13952369Floor Beam · corrodedFLOOR BEAM F.S. 313 CORRODED ON UPPER CAP FROM APPROX. RBL 16-LBL 16. REF TASK NR C-53-100-02. REPAIRED PER SRM 51-21-01, 53-21-00 PG 823-824.SDR DLL13952310Doubler · corrodedAT HMV, INSPECTION FOUND .020 BONDED DOUBLER CORRODED AT STA 325 RIGHT OF CENTERLINE. REMOVED DAMAGE SECTION OF EDGE DOUBLER AND INSTALLED REPAIR PER SRM 53-31-00 PG 863.SDR DLL13952309Skin Doubler · corrodedAT HMV, INSPECTION FOUND .020 EDGE DOUBLER AT SKIN SPLICE BOTTOM LEFT OF STR 33 AT STA 328 CORRODED. FABRICATED NEW EDGE DOUBLER SEGMENT IAW SRM 53-31-00 PG 863 AND INSTALLED.SDR DLL13952747Strap · corrodedFOUND DURING HMV, FAILSAFE STRAP LIFTED/CORRODED C-3 B/B FS 1745 BETWEEN STR 44 AND 45. REPAIRED PER SRM 53-31-00 FIG 801.SDR DLL13952522Tear Strap · disbondedAT HMV, FOUND TEAR STRAP DISBONDED AT FS 1783 BETWEEN STR 23 THROUGH 24. REPAIRED PER SRM 53-31-00 PG 830.SDR DLL13952521Frame · crackedAT HMV, FOUND FRAME CRACKED STA 267 RT SIDE OF E AND E ABOVE STR 9. REPAIRED PER SRM 53-12-00 FIG 805 AND DL ERA 271044-14.SDR DLL13952763Failsafe Strap · corrodedAT HMV, FUSELAGE SKIN FAILSAFE TEAR STRAP WAS FOUND LIFTED AND CORRODED AT FS 1525 TO FS 1545 STRINGER 35. ACCOMPLISHED REPAIRS PER ERA 270891-14 REV C.SDR DLL13952761Failsafe Strap · corrodedFAILSAFE STRAP LIFTED/CORRODED C2 BB AT FS 1403 TO 1423 STR 35 AND 36, FOUND AT HMV. REPAIRED PER SRM 53-31-00.SDR DLL13952756Floorbeam · corrodedAT HMV, FLOORBEAM CORRODED AFT OF FS 1505 BELOW LEFT FIXED FLOOR PANEL ABOVE STRINGER 40. REPAIRED PER SRM 53-23-00 FIG 802.SDR DLL13952755Frame · crackedAT HMV, FUSELAGE FRAME IN FESC LT SIDEWALL IS CRACKED AT FRAME SPLICE AT STA 281 BETWEEN STR 47 AND 48. REPAIRED PER SRM 53-12-00 FIG 814.SDR DLL13952750Stringer · corrodedFOUND DURING HMV, C-3 B/B STRINGER CORRODED FS 1645 TO 1725 STR 39. REPLACED DAMAGED STRINGER FROM FS 1675 TO 1695 PER SRM 53-13-00 PG 806.SDR DLL13952749Strap · corrodedFOUND DURING HMV, FAILSAFE STRAP LIFTED/CORRODED FROM FUSELAGE SKIN, FS 1685 TO 1705 BETWEEN STR 39 AND 40. REPAIRED PER SRM 53-31-00 FIG 801.SDR DLL13952748Strap · disbondedFOUND DURING HMV, FAILSAFE STRAP LIFTED/CORRODED C-3 B/B FS 1763 TO 1778 BETWEEN STR 43 TO 45. REPAIRED PER SRM 53-31-00 FIG 816.SDR DLL13952746Strap · corrodedFOUND DURING HMV, FAILSAFE STRAP LIFTED FROM SKIN C-3 B/B BETWEEN FS 1665 TO 1685 STR 43 AND 44. REPAIRED PER SRM 53-31-00 PG 807.SDR DLL13952745Strap · corrodedFAILSAFE STRAP LIFTED/CORRODED C-3 B/B FS 1725 BETWEEN STR 33 AND 34, FOUND DURING HMV. REPAIRED PER SRM 53-31-00. FIG 801.SDR DLL13952696P-Dome · corrodedAT HMV, FOUND P-DOME CORRODED, LOWER WEB AFT OF FS 1809 STRINGER 1809. REMOVED CORROSION, FABRICATED NEW SECTION, AND INSTALLED PER SRM 53-11-00 FIG 848.SDR DLL13952478Fail-Safe Strap · corrosionAT HMV, FOUND FAIL-SAFE STRAP CORRODED C3 B/B FS 1763 TO 1778 BETWEEN STR 43 TO 45. REPAIRED PER SRM 53-31-00.SDR DLL13952477Fail-Safe Strap · corrodedAT HMV, FOUND FAIL-SAFE STRAP CORRODED IN C3 B/B AT FS 1765 TO 1785 BETWEEN STR 42 TO 34. REPAIRED PER SRM 53-31-00.SDR DLL13952381Pressure Deck · crackedON HMV, FOUND RT PRESSURE DECK CRACKED STA 1243 6 INCHES INBD OF FRAME. REPAIRED PER SRM 53-11-00 FIG 844.
Back to N784DA, cancelled Jun 14, 2001