N814NW
Service difficulty reports · 215
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 = 'N814NW' 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 = 'N814NW' 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 DALA2020101203341Cylinder · no testDONT PASS OPERATIONAL TEST OF DAMPING DOOR R3 DOOR DAMPER CYLINDER IN PASSENGER CABIN. CORRECTIVE ACTION: REPLACED THE DOOR DAMPER CYLINDER AT DOOR R3, AS PER A330 AMM 52-22.SDR DALA2020100203250Cylinder · no testDONT PASS OPERATIONAL TEST OF DAMPING DOOR L3 DOOR DAMPER CYLINDER IN PASSENGER CABIN. CORRECTIVE ACTION: REPLACED THE DOOR DAMPER CYLINDER AT DOOR L3, AS PER A330 AMM 52-22.SDR DALA2020083102902Shear Pin · damaged1 LEFT CABIN DOOR ASSIST BOTTLE SHEAR PIN DAMAGED. CORRECTIVE ACTION: REPLACED PIN REF AMM 52-22. CHECKS GOOD.SDR DALA2019041502459Lens · brokenDOOR 3L OVERHEAD EXIT LENS ASSEMBLY BROKEN. REPLACED OVERHEAD EXIT LENS ASSEMBLY.SDR DALA2018100805916Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 33-37, +Y1959 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53276407. LP 0773980SDR DALA2018100305869Fitting · corrodedDURING M CHECK, FLOOR STRUCTURE FITTING AT CABIN FR 79-80, -Y1447.8 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F51470014.SDR DALA2018100305868Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 73-74, YC FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53478007.SDR DALA2018100305867Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 33-37, +Y1456 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53276401.SDR DALA2018100305866Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 33-37, -Y2462 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53276401.SDR DALA2018100305865Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 33-37.1, +Y2462 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53278800.SDR DALA2018100305864Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 33-37, -Y1456 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53276407.SDR DALA2018100305863Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 37-37.1, +Y450 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53278803.SDR DALA2018100305862Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 72-73, YA FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53478650.SDR DALA2018100305861Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 73, YA FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53478040.SDR DALA2018100305860Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 37-37.1, -Y1959 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53278800.SDR DALA2018100305859Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 32-34, -Y1456 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53278802.SDR DALA2018100305858Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 32-34, -Y1552.5 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53275639.SDR DALA2018100305857Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 33-37, +Y953 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53276401.SDR DALA2018100305856Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 37-37.1, +Y953 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53278800.SDR DALA2018100205814Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 73-74, YB FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53478040. LP 0766978SDR DALA2018100205813Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 33-37, -Y1959 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53276407. LP 0766972SDR DALA2018100205812Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 33-37, +Y2462 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53276401. LP 0766970SDR DALA2018100305872Structure · corrodedDURING M CHECK, FLOOR STRUCTURE AT CABIN FR 73-74 , Y-A TO -Y-B1 FOUND CORRODED. REPLACED FLOOR STRUCTURE PER SRM 51-42-11-001 AND DRAWING F53478040.SDR DALA2018100305871Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 32-34, -Y1552.5 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53275639.SDR DALA2018100305870Seat Track · corrodedDURING M CHECK, SEAT TRACK AT CABIN FR 32-34, +Y1552.5 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11-001 AND DRAWING F53275638.SDR DALA2018092700267Seat Track · corrodedDURING H CHECK, SEAT TRACK AT FR 53.4 AND 53.5, +Y450 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11 AND AIRBUS DRAWING F53326973. LP 0759435SDR DALA2018092700266Seat Track · corrodedDURING H CHECK, SEAT TRACK AT FR 14-15, Y-450 FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-42-11 AND AIRBUS DRAWING F53116374. LP 0759433SDR DALA2018092700264Seat Track · corrodedDURING H CHECK, SEAT TRACK AT FR 53.1-53.2, +Y450 FOUND CORRODED. REMOVED DAMAGED AREA AND INSTALLED REPAIR PER SRM 53-31-15-300-001 AND SRM 51-42-11. LP 0758532SDR DALA2016120209505Piston · corrodedWHILE UNDERGOING L-CHECK, THE SUBJECT AIRPLANE WAS FOUND WITH CORROSION ON THE SLIDING PISTON LOCATED ON LEFT MAIN LANDING GEAR SHOCK STRUT CAPSULE. LOCALLY BLEND CORRODED AREA, FLAP PEEN THE REWORKED AREA, APPLY CADMIUM PLATING AND APPLY 2 COATS OF PRIMER PASDR DALA2016120209504Piston · corrodedWHILE UNDERGOING L-CHECK, THE SUBJECT AIRPLANE WAS FOUND WITH CORROSION ON THE SLIDING PISTON LOCATED ON R/H MAIN LANDING GEAR SHOCK STRUT CAPSULE. LOCALLY BLEND CORRODED AREA, FLAP PEEN THE REWORKED AREA, APPLY CADMIUM PLATING AND APPLY 2 COATS OF PRIMER PAISDR DALA2016112300213Lens · missingDURING SERVICE CHECK FOUND 1 EMERGENCY LIGHT LENS COVER AT AFT R4 DOOR. REPLACED THE LENS.SDR DALA2016111408779Light · damagedEMERGENCY SEAT MOUNTED LIGHT DAMAGED AT SEAT 14H. SECURED LIGHT.SDR DALA2016091706751Seat Track · corrodedAFT CABIN SEAT TRACK AT FRAMES 73 - 74 FOUND CORRODED. REPLACED THE SEAT TRACK IAW SRM 51-42-11.SDR DALA2016091706748Seat Track · corrodedAFT CABIN SEAT TRACK AT FRAMES 73 - 74 FOUND CORRODED. REPLACED THE SEAT TRACK IAW SRM 51-42-11.SDR DALA2016091706747Seat Track · corrodedAFT CABIN SEAT TRACK YB 1 LEFT AT FRAMES 73 TO 74 FOUND CORRODED. REPLACED THE SEAT TRACK IAW SRM 51-42-11.SDR DALA2016091706746Seat Track · corrodedAFT CABIN SEAT TRACK -YC AT FRAMES 73 TO 74 FOUND CORRODED. REPLACED THE SEAT TRACK IAW SRM 51-42-11.SDR DALA2016091706745Seat Track · corrodedAFT CABIN SEAT TRACK -YA AT FRAMES 73 TO 74 FOUND CORRODED. REPLACED THE SEAT TRACK IAW SRM 51-42-11.SDR DALA2016091706744Seat Track · corrodedAFT CABIN SEAT TRACK -Y450 AT FRAMES 72 TO 75 FOUND CORRODED. REPLACED THE SEAT TRACK IAW SRM 51-42-11.SDR DALA2016091706743Seat Track · corrodedAFT CABIN SEAT TRACK YB 1 AT FRAMES 73 TO 74 FOUND CORRODED. REPLACED THE SEAT TRACK IAW SRM 51-42-11.SDR DALA2016091706742Seat Track · corrodedAFT CABIN SEAT TRACK YB AT FRAMES 73 TO 74 FOUND CORRODED. REPLACED THE SEAT TRACK IAW SRM 51-42-11.SDR DALA2015122707729Battery Pack · no testDURING INSPECTION, LDMCR EPSU BATTERY TEST FAILED. REPLACED LDMCR EPSU BATTERY.SDR DALA2015122607728Battery Pack · no testDURING INSPECTION, DOOR 1R AND 1L EPSU BATTERY FAILED TEST. REPLACED DOOR 1R AND 1L EPSU BATTERY.SDR DALA2015122607727Battery Pack · no testDURING INSPECTION, DOOR 2R AND 2L EPSU BATTERY FAILED TEST. REPLACED DOOR 2R AND 2L EPSU BATTERY.SDR DALA2015122607726Battery Pack · no testDURING INSPECTIONS, DOOR 4R AND 4L EPSU BATTERY TEST FAILED. REPLACED DOOR 4R AND 4L EPSU BATTERY.SDR DALA2015122607725Battery Pack · no testDURING INSPECTION, DOOR 3R AND 3L EPSU BATTERY FAILED TEST. REPLACED DOOR 3R AND 3L EPSU BATTERY. LP 8016646.SDR DALA2015120607413Skin · dentedDURING WALK-AROUND, FOUND L4 DOOR CONTOUR AFT LOWER CORNER FOUND DENTED. INSTALLED TEMP DOUBLE AND FILLER REPAIR IAW ER/A 14-541813. REMOVED TEMP REPAIR AND INSTALL PERMANET REPAIR DOUBLE AND FILLER ER/A 14-541813, SECTION 2.SDR DALA2014122706771Power Supply · inoperativeEMERGENCY LIGHTS WILL NOT SHUTOFF AT DOOR 3R. R & R EPSU.SDR DALA2014120106293Connector · damagedR3 DOOR EMERGENCY EXIT SIGN INOPERATIVE. PIN 1 NOT INSTALL PROPERLY, REINSTALLED.SDR DALA2014102705758Connector · unsecureCEILING EMERGENCY LIGHTS AT ROWS 22, 33 & 41 INOPERATIVE. RESEATED THE CONNECTORS .SDR DALA13011153314Skin · damagedBIRDSTRIKE DAMAGE ON SLAT NR 5 DENT 12" LONG, 5.5" HIGH, 1" DEEP BETWEEN D NOSE FRAMES 2 AND 3 COUNTING FROM INBD. REFORMED RIB AND INSTALLED SHIM IAW ER/A 512430-14 AND SRM 57-40 LP 8552383.
Back to N814NW