N363NW
Service difficulty reports · 223
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 = 'N363NW' AND registry_match = 'registration' 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 = 'N363NW' AND registry_match = 'registration' 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 DALA2017021301178Terminal Block · failedCEILING EMERGENCY LIGHT AT ROW 28 INOPERATIVE. FOUND THE TERMINAL BLOCK 7225VT NR 13 AT FAULT, REPLACED THE TERMINAL BLOCK.SDR DALA2016022301475Floor Support · corrodedCORROSION AFT GALLEY AREA ON LOWER SILL FR 66-FR 68 AT LEVEL STR 23L MEASURES APPROXIMATELY L:0.600", W:0.270", D:0.003". REPLACED LOWER SILL FR 66-FR 68 AT LEVEL, STR 23L AT AFT GALLEY AREA ASPER SRM 51-72-11 AND DWG D53480020, THE DEEPEST POINT MEASURE IS: SDR DALA2016022001480Shear Tie · corrodedCORROSION ON CLEAT ON FRAME 26 IN FWD CARGO COMPARTMENT BETWEEN STR 43L TO STRINGER 43R. REPLACED CLEAT ON FR 26 IN FWD CARGO COMPARTMENT BETWEEN STR 43L TO STR 43R IAW SRM 51-72-11 AND DWG D53230324 AND D53231712.SDR DALA2016022001479Slat · damagedMISSING MATERIAL ON T/E SLAT 3 LOCATED 10 FROM INBD EDGE ON LT WING. PERFORMED PERMANENT REPAIR ON T/E SLAT 3 LOCATED AT 10" FROM INBD EDGE ON LT WING IAW SRM 57-44-21, PARA 5.A, FIG 202.SDR DALA2016021901478Floor Support · corrodedCORROSION ON FLOORBEAM +Y160, FRAME 68 TO FRAME 70 MEASURES APPROXIMATELY L=0.950, W=0.320, D=0.002 AT AFT GALLEY AREA. REPLACED FLOORBEAM, +Y160 LOCATED FRAME 68 TO FRAME 70 AFTER GALLEY AREA AND FASTENERS IAW SRM 51-72-11, 51-42-11 AND DWG D53474250.SDR DALA2016021901477Shear Tie · corrodedCORROSION ON SHEAR TIE LOCATED BETWEEN STR 41R AND STR 42R AT LEVEL FR 30 IN FWD CARGO COMPARTMENT L=0.300, W=0.200, D=0.002. REPLACED SHEAR TIE LOC BETWEEN STR 41R AND STR 42R AT FRAME 30 LEVEL FWD CARGO COMPARTMENT IAW SRM 51-72-11 AND DWG D53231586.SDR DALA2016021601209Plate · crackedTWO CRACK INDICATIONS ON SIDE BOX BEAM AT FRAME 43 Y- 1650. REPLACED PREASURE PLATE IAW SRM 51-72-11.SDR DALA2016021601208Floor Support · corrodedCORROSION ON FLOOR SUPPORT -Y765, FRAMES 12 - 24 . REPLACED THE FLOOR SUPPORT IAW SRM 51-72-11, DWG D5311281, AND D53110900.SDR DALA2016021601207Plate · crackedTWO CRACK INDICATIONS ON SIDE BOX BEAM AT FRAME 43, Y+1650 ON CENTER WING BOX . REPLACED PRESSURE PLATE LT SIDE FRAME 43 IAW SRM 51-72-11.SDR DALA2016021601206Floor Support · corrodedCORROSION ON FLOOR SUPPORT -Y254, FRAMES 12 - 24. REPLACED THE FLOOR SUPPORT IAW SRM 51-72-11 AND DWG D53110900.SDR DALA2016021501205Shear Tie · corrodedCORROSION ON SHEAR TIE BETWEEN STRINGERS 40 - 41R AT FRAME 31. REPLACED THE SHEAR TIE IAW SRM 51-72-11 AND DWG D53231586.SDR DALA2016021501204Shear Tie · corrodedCORROSION ON SHEAR TIE BETWEEN STRINGERS 42 - 43R AT FRAME 32. REPLACED THE SHEAR TIE IAW SRM 51-72-11 AND DWG D53231712.SDR DALA2016021501203Shear Tie · corrodedCORROSION ON SHEAR TIE BETWEEN STRINGERS 43 - 44L , FRAME 31. REPLACED THE SHEAR TIE IAW SRM 51-72-11 AND DWG D53231712.SDR DALA2016021501202Shear Tie · corrodedCORROSION ON SHEAR TIE BETWEEN STRINGERS 41 - 42R AT FRAME 31. REPLACED THE SHEAR TIE IAW SRM 51-72-11 AND DWG D53231586.SDR DALA2016021501201Floor Support · corrodedCORROSION ON FLOOR SUPPORT +Y254, FRAME 20+5. REPLACED THE FLOOR SUPPORT BETWEEN FRAMES 12 TO 24 IAW SRM 51-72-11 AND DWG D53112816.SDR DALA2016021501200Floor Support · corrodedCORROSION ON FLOOR SUPPORT -Y1162, FRAMES 67+15 TO 69. REPLACED THE FLOOR SUPPORT IAW SRM 51-42-11 AND DWG D53472800.SDR DALA2016021501199Floor Support · corrodedCORROSION ON FLOOR SUPPORT -Y1225 FRAMES 66+5" TO 67+15. REPLACED THE FLOOR SUPPORT IAW SRM 51-42-11 AND DWG B53472800.SDR DALA2016021401198Shear Tie · corrodedCORROSION ON SHEAR TIE LOCATED BETWEEN STR 40R TO STR 41R AT LEVEL FRAME 30. REPLACED THE SHEAR TIE IAW SRM 51-72-11 AND DWG D53231586.SDR DALA2016021501190Floor Support · corrodedCORROSION ON FLOORBEAM +Y1162, FRAME 67+15" TO FRAME 69 MEASURES APPROXIMATELY L:0.600", W:0.300", D:0.002", SSI 534147 AT AFT GALLEY AREA. REPLACED FLOORBEAM +Y1162 LOCATED BETWEEN FRAME 67+15" TO FRAME 69 IAW SRM 51-72-11 AND DWG D53472800.SDR DALA2016021301196Floor Support · corrodedCORROSION ON FLOOR SUPPORT +Y1225, FRAMES 66+5" TO 67+15". REPLACED THE FLOOR SUPPORT IAW SRM 51-72-11 AND DWG D53472800.SDR DALA2016021301195Dummy Rail · corrodedCORROSION ON RAIL DUMMY Y503.2 LOCATED FRAMES 12 TO 16. REPLACED THE RAIL DUMMY IAW SRM 51-72-11 AND DWG D53112825.SDR DALA2016021301194Floor Support · corrodedCORROSION ON FLOOR SUPPORT +Y765, FRAMES 66+5" TO 70. REPLACED THE FLOOR SUPPORT IAW SRM 51-72-11 AND DWG D53472800.SDR DALA2016020900957Seat Track · corrodedCORROSION ON SEAT TRACK -Y1292, FRAMES 12 TO 20. REPLACED THE SEAT TRACK IAW SRM 51-72-11 AND DWG D53112812.SDR DALA2016012701158Stringer · corrodedFOUND AREAS OF CORROSION COMMON TO STR 43L, BETWEEN FR 56 TO FR 57. REPAIR SRM 53-00-13 PARA 4.B AND FIG 201.SDR DALA2014080804376Wire · brokenDURING NON ROUTINE CHECK, FOUND EMERGENCY LIGHT INOPERATIVE AT SEAT 7C. MAINTENANCE FOUND BROKED WIRE UNDER SEAT 7A; REPAIRED WIRE AND FUNCTIONAL CHECKED NORMAL.SDR DALA2014080804373Wire · brokenDURING NON-ROUTINE CHECK, FOUND EMERGENCY LIGHT INOPERATIVE AT SEAT 3B AFT LIGHT ASSY. MAINTENANCE FOUND BROKEN WIRE UNDER SEAT. RECONNECTED WIRE AND FUNCTIONAL CHECK WAS NORMAL.SDR DALA2016021501159Skin · damagedSKIN DAMAGED 38 INCHES AFT OF L1 DOOR, 2 INCHES BLOW FLOOR LINE, STRINGER 23, FRAME 23. PERMANENT REPAIR ON EXTERNAL SKIN ON FRAME 23 AT LEVEL OF STR 23L IAW SRM 53-00-11 PARA 4W FIGURE 240.SDR DALA13024333263Wire · damagedEMERGENCY PATH LIGHT AT SEAT ROW 22/ 21 INOPERATIVE. FOUND WIRING AT UNDERSEAT CONNECTORS BAD RETERMINATED CONNECTOR IAW SWPM. CHECKED GOOD.SDR DALA13009403263Connector · disconnectedDURING NON ROUTINE CHECK, FOUND SEAT 23C EMERGENCY PATH LIGHT INOPERATIVE. MX RECONNECTED PULLED OUT CONNECTOR TO LIGHT ASSY AND FUNCTIONAL CHECK WAS NORMAL.SDR DALA12012463263Connector · unsecureDURING NON ROUTINE CHECK, FOUND EMERGENCY LIGHT TEST FAILS EPSU INT LOAD AFT LEFT. MX RESEATED CONNECTOR AT EPSU 13WL AND FUNCTIONAL CHECK WAS NORMAL..SDR DALA12008923263Wire · brokenDURING NON ROUTINE CHECK, FOUND SEAT 26C EMERGENCY PATH LIGHT INOPERATIVE. MX REPAIRED BROKEN WIRE UNDER SEAT AND FUNCTIONAL CHECKED NORMAL.SDR DALA12000293263Wire Harness · damagedDURING NON ROUTINE CHECK, FOUND THE EMERGENCY PATH LIGHT AT SEAT ROW 4 INOPERATIVE. MAINTENANCE REPLACED EMERGENCY LIGHT WIRE HARNESS AT SEAT 4ABC AND FUNCTIONAL CHECKED NORMAL.SDR DALA1208833263Power Supply · malfunctionedDURING NON ROUTINE CHECK, FOUND THE EPSU LIGHT TEST FAULTS AT AFT LT. MAINTENANCE RESET POWER SUPPLY AND FUNCTIONAL CHECK WAS NORMAL. AIRCRAFT RETURNED TO SERVICE.SDR DALA1150933263Power Supply · inoperativeDURING NON ROUTINE CHECK, FOUND THE EMERGENCY LIGHT AT RIGHT REAR FAILED EPSU TEST. MAINTENANCE REPLACED POWER SUPPLY AND FUNCTIONAL CHECK WAS NORMAL. AIRCRAFT RETURNED TO SERVICE.SDR DALA1147873263Wire · disconnectedDURING NON ROUTINE CHECK, FOUND THE EMERGENCY SEAT ESCAPE PATH LIGHT AT ROWS 12C, 18C, AND 26C INOPERATIVE. MAINTENANCE RECONNECTED WIRE AND FUNCTIONAL TEST WAS NORMAL. AIRCRAFT RETURNED TO SERVICE.SDR DALA1129793263Epsu · inoperativeDURING A NON ROUTINE CHECK, FOUND THE EMERGENCY EXIT PATH LIGHT AT ROWS 12, 13, 16, 17, 20, 21, 25, AND 26 INOPERATIVE. MAINTENANCE REPLACED EPSU AT ROW 13WL AND FUNCTIONAL CHECK WAS NORMAL. AIRCRAFT RETURNED TO SERVICE.SDR DALA1115183263Wire Harness · inoperativeDURING A NON ROUTINE CHECK, FOUND THE EMERGENCY ESCAPE PATH LIGHT AY AT ROW 22C INOPERATIVE. MAINTENANCE REPLACED HARNESS AND FUNCTIONAL CHECK WAS NORMAL. AIRCRAFT RETURNED TO SERVICE.SDR DALA1020653263Connector · looseF/A REPORTED BOTH EMERGENCY ESCAPE PATH LIGHTS ROW NR 1 WERE INOP, FOUND CONNECTOR LOOSE AND SECURED AND TESTS OK.SDR DALA1020553263Light · missingREPORTED BY CREW OFF FLIGHT 1568 SEAT 5ABC EMERGENCY PATH LIGHT MISSING, REPLACED LIGHT AND TESTED OK.SDR DALA1015403263Floor Panel · damagedDURING M-CHECK FOUND DAMAGE TO FLOOR PANEL 131HF. REPAIRED PER DWG 3D25-37705.SDR DALA1015393263Floor Panel · damagedDURING M-CHECK FOUND DAMAGE TO FLOOR PANEL 151AF. REPAIRED PER DWG 3D25-37705.SDR DALA1015383263Floor Panel · damagedDURING M-CHECK FOUND DAMAGE TO FLOOR PANEL 151DF. REPLACED PER DWG 3D25-37705.SDR DALA1015373263Floor Panel · delaminatedDURING M-CHECK FOUND DELAMINATION ON FLOOR PANEL 151GF. REPLACED FLOOR PANEL PER DWG 3D25-37705.SDR DALA1015363263Floor Panel · delaminatedDURING M-CHECK FOUND DELAMINATION ON FLOOR PANEL 242GF. REPLACED FLOOR PANEL PER DWG 3D25-37498.SDR DALA1015353263Floor Panel · delaminatedDURING M-CHECK FOUND DELAMINATION ON FLOOR PANEL 241CF. REPLACED FLOOR PANEL PER DWG 3D25-37498.SDR DALA1014983263Seat Track · corrodedDURING M-CHECK FOUND CORROSION ON SEAT TRACK AT Y1292 BETWEEN FR68 & FR69. REPAIRED PER SRM 51-42-11.SDR DALA1014973263Seat Track · corrodedDURING M-CHECK FOUND CORROSION ON SEAT TRACK AT Y1292 BETWEEN FR64 & FR66. REPAIRED PER SRM 51-42-11.SDR DALA1014963263Seat Track · corrodedDURING M-CHECK FOUND CORROSION ON SEAT TRACK AT Y1292 BETWEEN FR66 & FR68. REPAIRED PER SRM 51-42-11.SDR DALA1014953263Floor Panel · corrodedDURING M-CHECK FOUND CORROSION ON FLOOR PANEL 262FF. REPAIRED PER SRM 51-72-00.SDR DALA1014943263Sill · corrodedDURING M-CHECK FOUND CORROSION ON LT DOOR SILL AT FR68. REPAIRED PER SRM 51-42-14 FIGURE 201.
Back to N363NW