N364NW
Service difficulty reports · 149
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 = 'N364NW' 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 = 'N364NW' 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 DALA2015120307400Floor Support · corrodedCORROSION ON FLOOR SUPPORT -Y1162 BETWEEN FRAME 68 TO FRAME 69. REPLACED THE FLOOR SUPPORT IAW SRM 51-72-11 AND DWG D53472845.SDR DALA2015120207395Dummy Rail · corrodedCORROSION ON RAIL DUMMY Y503.2 BETWEEN FRAME 12 TO FRAME 16 AT FWD GALLEY AREA L=1.000", W=0.800", D=0.010", REPLACED RAIL DUMMY, Y503.2 BETWEEN FRAME 12 TO FRAME 16 AT FWD GALLEY AREA IAW SRM 51-72-11 AND DWG D53112825 AND D53110984. MEASURES OF CORROSION ARSDR DALA2015112807719Skin · damagedLIGHTNING STRIKE ON FASTENER HEAD EXTERNAL SKIN AT FRAME 4, 31" ABOVE OF LT SIDE STRINGER AT LOWER FUSELAGE, PERFORMED PERMANENT REPAIR ON FRAME 4 , 31 ABOVE OF LT SIDE STRINGER AT LOWER FUSELAGE IAW SRM 53-11-11.SDR DALA2015112807718Skin · damagedLIGHTNING STRIKE ON FASTENER HEAD EXTERNAL SKIN AT FRAME 3, 23" ABOVE OF LT SIDE STRINGER AT LOWER FUSELAGE, PERFORMED PERMANENT REPAIR ON FRAME 3, 23 ABOVE OF LT SIDE STRINGER AT LOWER FUSELAGE IAW SRM 53-11-11.SDR DALA2015112807717Skin · damagedLIGHTNING STRIKE ON FASTENER HEAD EXTERNAL SKIN AT FRAME 4, 29" ABOVE OF LT SIDE STRINGER AT LOWER FUSELAGE. PERFORMED PERMANENT REPAIR ON FRAME 4, 29 ABOVE OF LT SIDE STRINGER AT LOWER FUSELAGE IAW SRM 53-11-11.SDR DALA2015111206954Wire · brokenROW 20 AND 21 SEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE, REPAIRED BROKEN WIRE UNDER SEAT.SDR DALA2015120207396Floor Support · corrodedCORROSION ON FLOOR SUPPORT +Y254 BETWEEN FRAME 12 TO FRAME 24. REPLACED THE FLOOR SUPPORT IAW SRM 51-72-11 AND DWG D53110920 AND D53112816.SDR DALA1516503264Frame · corrodedFUSELAGE, RT FRAME 20 AT FLOOR LEVEL, CORRODED. REPAIRED IAW ERA 480338-14, LOG 1925533, 0205323, 0204609.SDR DALA2014091004966Wire · brokenDURING NON ROUTINE CHECK, FOUND SEAT 17C EXIT LIGHT OUT INOPERATIVE. MAINTENANCE FIXED BROKEN WIRE AT ROW 17C OPS CHECK WAS NORMAL.SDR DALA14029473264Battery Pack · no testDURING NON ROUTINE CHECK, FOUND EMERGENCY LIGHT TEST SHOWS EPSU BATTERY FWD L AND EPSU INT LOAD EMERGECY R. MAINTENANCE REPLACED L FWD BATTERY AND RT EMERGENCY EXIT EPSU AND BATTERY. FUNCTIONAL CHECKED NORMAL.SDR DALA13043283264Connector · unsecureDURING NON ROUTINE CHECK, FOUND EMERGENCY ESCAPE PATH LIGHT AT SEAT 25C INOPERATIVE. MX SECURED LOOSE CONNECTOR AND FUNCTIONAL CHECK WAS NORMAL.SDR DALA1200563264Epsu · inoperativeDURING NON ROUTINE CHECK, FOUND THE EMERGENCY LIGHT SYSTEM TEST FAULTS "EPSU EXIT LOAD L". MAINTENANCE REPLACED LT EPSU AND FUNCTIONAL CHECK WAS NORMAL. AIRCRAFT RETURNED TO SERVICE.SDR DALA1164813264Light · inoperativeDURING NON ROUTINE CHECK, FOUND LEFT CABIN EPSU FAILED TO TEST. MAINTENANCE REPLACED LED AT LEFT WALL EMERGENCY EXIT SIGN AND OPERATIONAL CHECK WAS NORMAL. AIRCRAFT RETURNED TO SERVICE.SDR DALA1163263264Battery · dischargedDURING NON ROUTINE CHECK, FOUND FWD LT CABIN EPSU FAILED TO TEST. MAINTENANCE REPLACED EPSU BATTERY AND OPERATIONAL CHECK WAS NORMAL. AIRCRAFT RETURNED TO SERVICE.SDR DALA1149203264Floor Panel · damagedFWD CARGO FLOOR PANEL HAS NUMEROUS HOLES & PANEL FASTENER INSERTS MISSING. REMOVED & REPLACED FWD CARGO FLOOR PANEL 131AF FOR SVC.SDR DALA1516483264Skin · damagedFUSELAGE SKIN BETWEEN FRAMES 66-68, MISDRILLED HOLES BELOW R2 DOOR. REPAIRED IAW ERA 480602-14.SDR DALA106413264Structure · misrepairedDURING M-CHECK WHILE ACCOMPLISHING DOOR SILL REPLACEMENT AT DOOR R2 FOUND 7 MISDRILLED FASTENER HOLES BETWEEN FR66 AND FR68. THE HOLES ARE COMMON TO THE FUSELAGE SKIN, DOUBLER AND DOOR SILL. ERA 480602-14 REPAIR TO BE ACCOMPLISHED AS FOLLOWS: SECTION I ACCOMPSDR DALA106483264Stringer · crackedDURING M-CHECK FOUND STRINGER 23R CRACKED AROUND RIVET. REPAIRED IAW ERA 480944-14, SRM 51-44-11, 51-21-11, 51-42-11.SDR DALA106423264Floor Panel · damagedDURING M-CHECK, FOUND FLOOR PANEL 131HF DAMAGED. FABRICATED REPLACEMENT FLOOR PANEL IAW DWG 3D25-37705.SDR DALA106723264Seat Track · corrodedDURING M-CHECK FOUND SEAT TRACK -Y1292 CORRODED BETWEEN FR 64 AND 66. REPLACED SEAT TRACK IAW SRM 51-42-11, AND 51-44-11.SDR DALA106813264Floor Panel · corrodedDURING M-CHECK FOUND FLOOR PANEL 261FF CORRODED. REPLACED FLOOR PANEL IAW SRM 51-72-00.SDR DALA106803264Floor Panel · corrodedDURING M-CHECK, FOUND FLOOR PANEL 222FF CORRODED. REPLACED FLOOR PANEL.SDR DALA106793264Floor Panel · corrodedDURING M-CHECK, FOUND FLOOR PANEL 262FF CORRODED. REPLACED FLOOR PANEL IAW SRM 51-72-00.SDR DALA106733264Seat Track · corrodedDURING M-CHECK FOUND SEAT TRACK -Y1292 WAS CORRODED AT FR67 AND 69. REPLACED SEAT TRACK IAW SRM 51-44-11, AND 51-42-11.SDR DALA106713264Seat Track · corrodedDURING M-CHECK, FOUND SEAT TRACK CORRODED AT -Y1292, FR66 TO 68. REPLACED SEAT TRACK IAW SRM 51-42-11, AND 51-44-11.SDR DALA106453264Floor Panel · dentedDURING M-CHECK FOUND FLOOR PANEL 131EF WITH MULTIPLE DENTS. FABRICATED REPLACEMENT FLOOR PANEL IAW DWG 3D25-37705.SDR DALA106446264Floor Panel · dentedDURING M-CHECK FOUND FLOOR PANEL 131AF WITH MULTIPLE DENTS. FABRICATED REPLACEMENT FLOOR PANEL IAW DWG 3D25-37705.SDR DALA106393264Floor Panel · damagedDURING M-CHECK FOUND FLOOR PANEL 262EF DAMAGED. FABRICATED REPLACEMENT FLOOR PANEL IAW DWG 3D25-37705.SDR DALA106383264Floor Panel · damagedDURING M-CHECK FOUND FLOOR PANEL 261AB DAMAGED. FABRICATED REPLACEMENT FLOOR PANEL IAW DWG 3D25-37705.SDR DALA106373264Floor Panel · damagedDURING M-CHECK, FOUND FLOOR PANEL 261PF DAMAGED. FABRICATED REPLACEMENT FLOOR PANEL IAW DWG 3D25-37705.SDR DALA106773264Seat Track · corrodedAFT UTILITY AREA SEAT TRACK AT +Y1292 BETWEEN FR66 & FR68 CORRODED. FOUND TO BE OUT OF LIMITS IAW TRM 53-41-15 FIG I W=1.950 L=2.005 D=0.055. PN D5347217220290. REPLACED SEAT TRACK & SPLICES IAW SRM 51-42-11.SDR DALA106763264Seat Track · corrodedAFT UTILITY AREA SEAT TRACK AT +Y1292 BETWEEN FR67 & FR69 CORRODED AT FWD SPLICE. FOUND TO BE OUT OF LIMITS IAW TRM 53-41-15 FIG I L=1.895 W=1.025 D=.063. REPLACED SEAT TRACK FR64 TO 69 IAW SRM 51-42-11. PN D5347218820400.SDR DALA106753264Seat Track · corrodedAFT UTILITY AREA SEAT TRACK AT +Y1292 BETWEEN FR64 & FR66 CORRODED OUT OF LIMITS IAW TRM 53-14-15, FIG I W=1.950 L=2.60 D=.059. REPLACED SEAT TRACK IAW SRM 51-42-11.SDR DALA106783264Sill · gougedDURING M-CHECK, FOUND DOOR 2 RT AFT CORNER SILL HAS GOUGE MARKS. REPLACED SILL IAW SRM 51-44-11, AND 51-42-11.SDR DALA106363264Sill · gougedDURING M-CHECK, FOUND DOOR R2 FWD CORNER OF SILL HAS GOUGE AND TOOL MARKS. R & R SILL IAW SRM 51-44-11 AND 51-42-11.SDR DALA106023264Angle · crackedDURING M-CHECK FOUND CRACK IN ANGLE AT LOWER FUSELAGE JUST AFT OF YELLOW HYDRAULIC SYSTEM ACCUMULATOR. REPAIRED PER SRM 53-31-29 & 51-42-11.SDR DALA105683264Floor Support · corrodedDURING H-CHECK, FOUND CORROSION ON FLOOR SUPPORT BEAM AT Y1292 FR 20. REPAIRED PER SRM 51-42-11.SDR DALA105673264Sill · corrodedDURING H-CHECK, FOUND CORROSION ON L2 DOOR SILL. REPAIRED PER SRM 51-44-11 AND 51-42-11.SDR DALA105663264Support · corrodedDURING H-CHECK, FOUND CORROSION ON LT FRAME SUPPORT AT Y1292 BETWEEN FR 69 AND FR 70. REPAIRED PER SRM 51-42-11.SDR DALA105653264Support · corrodedDURING H-CHECK FOUND CORROSION ON RT FRAME SUPPORT AT Y1292 BETWEEN FR 69 AND FR 70. REPAIRED PER SRM 51-42-11.SDR DALA105643264Support · crackedDURING H-CHECK, FOUND CRACK IN AFT CABIN LT DIAGONAL SUPPORT BEAM AT FR 68. REPAIRED PER SRM 51-42-11.SDR DALA105633264Seat Track · corrodedDURING H-CHECK FOUND SEAT TRACK CORRODED AT Y765 BETWEEN FR 64 AND FR 66. REPAIRED PER SRM 51-42-11.SDR DALA105533264Seat Track · corrodedDURING "M" CHECK FOUND CORROSION ON SEAT TRACK AT -Y765 BETWEEN FR66 AND FR70. REPAIRED IAW SRM 51-42-11.SDR DALA105523264Floorbeam · corrodedDURING "M" CHECK FOUND CORROSION ON FLOOR SUPPORT BEAM AT -Y189 FR 20. REPAIRED IAW SRM 51-42-11.SDR NWAA09633264Filter · dirtyDURING FLIGHT, VERY STRONG DE-ICE FLUID ODOR THROUGHOUT AIRCRAFT. REPLACED RECIRCULATION FILTERS 4012HN, 4013HM AND CATALLYTIC CONVERTERS NR 1 AND NR 2, CHECK OK. (K)SDR NWAA085643264Safety Valve · leakingIN CRUISE ECAM MSG HYD G RSVR LO LVL. COM FOLLOWED WITH GRAVITY GEAR EXTENSION PRIOR TO LANDING. UNEVENTFUL LANDING WITH ACFT TOWED TO GATE. REPLACED LANDING GEAR SAFETY VALVE 49GA, CHECKS OK.SDR NWAA082913264Power Supply · inoperativeAFTER GEAR EXTENSION, EXIT SIGNS DID NOT ILLUMINATE FOR AFT DOORS. REPLACED EPSU 13WL, CHECKS GOOD. (A)SDR NWAA080183264Hydraulic System · emptyALL HYDRAULIC FLUID GONE FROM YELLOW HYDRAULIC SYSTEM. PERFORMED HYD RSVR LO LVL PROC AS PER COM. AIRCRAFT LANDED UNEVENTFULLY AND WAS TOWED TO GATE.SDR 0102193264O-Ring · leakingDURING CRUISE, CREW RECEIVED HYDRAULIC GREEN RESERVOIR LEVEL LOW ECAM WARNING. CREW FOLLOWED COM PROCEDURE AND DIVERTED TO LAX. MAINTENANCE REPLACED O-RING FILTER ON NR 5 SPOILER FILTER HOUSING AND SERVICED HYDRAULIC SYSTEM. LEAK AND OPERATIONAL CHECK NORMAL
Back to N364NW