N551NW
Service difficulty reports · 131
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 = 'N551NW' 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 = 'N551NW' 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 DALA2015120407483Strap · crackedSTABILIZER STRAP AT BS 370, LBL 45 CRACKED. REPAIRED CRACK ON STABILIZER STRAP, BS 370 LBL 45 REF: SRM.SDR DALA2015120107344Skin · dentedEXTERNAL UPPER FUSELAGE DENT LOCATED APPROXIMATELY BS 530, STR 3L. FOUND WITHIN ALLOWABLE LIMITS OF SRM 53-00-01, PG 104, DETAIL III. ACCOMPLISHED HFEC INSP IAW NDT PT6 51-00-19, NO DEFECTS NOTED.SDR DALA2015121807669Sidewall Panel · corrodedAFT CARGO COMP RT SIDE PANEL HAS CORROSION AT APPROXIMATELY BS 1445 UPPER SURFACE. R & R IAW SRM 51-40-02 AND DWG 146N5392, REV B; RT SIDE TRANSITION PANEL FROM BS 1400 TO 1480 PN 146N5391 A-TAG NR 64117. CLOSED LOG AND REMOVED MONITOR INSPECTION.SDR DALA2015111907082Skin · damagedEXTERNAL FUSELAGE CROWN HAS DAMAGE FROM LIGHTNING STRIKE APPROXIMATELY BS 1560 BETWEEN STR 1 AND 2 LT. REMOVED DAMAGE ON EXTERNAL FUSELAGE CROWN APPROXIMATELY STA 1560 BETWEEN STR 1 AND 2 LT IAW SRM 53-00-01, TREATED AND PRIMED AREA IAW SRM 51-21-01 AND TOPCSDR DALA2015111907081Skin · damagedUPPER FUSELAGE SKIN DAMAGE FROM LIGHTNING STRIKE AT BS 765 BETWEEN STR 8R TO 9R. REMOVED DAMAGE ON UPPER FUSELAGE SKIN AT BS 765 BETWEEN STR 8R TO 9R, IAW SRM 53-00-01. TREATED AND PRIMED AREA IAW SRM 51-71-01 AND TOPCOATED AREA IAW AMM 51-21-10-377-037.SDR DALA2015092105756Battery Pack · inoperativeL2 EMERGENCY LIGHTS OUT. REPLACED M733 BATTERY PACK, OPS CK GOOD.SDR DALA2015080804908Skin · damagedLIGHTNING STRIKE DAMAGE AT FS 627 BETWEEN STR S28L -29L. BLENDED AREA IAW SRM 53-00-01, FOUND TO BE OUT OF LIMITS; REMOVED DAMAGED AREA IAW SRM 53-00-01, REPAIR 14; C/W EDDY CURRENT INSPECTION AT CUTOUT IAW-SRM 53-00-01, REPAIR 14, STEP 3. NO ITEMS NOTED FASDR DALA2015080804907Skin · damagedLIGHTINING STRIKE DAMAGE AT FS 529 BETWEEN STR 29L AND 28L. BLENDED AREA IAW SRM 53-00-01, FOUND TO BE OUT OF LIMITS. REMOVED DAMAGED AREA IAW SRM 53- 00-01, REPAIR NR 2. REMOVED FASTENERS COMMON TO REPAIR IAW SRM 53-00-01, REPAIR NR 2. C/W EDDY CURRENT INSPSDR DALA2015062403924Wire · damagedMAINTENANCE FOUND SEAT ROW 22 EMERGENCY LIGHTS INOPERATIVE. DAMAGE WIRING WAS FOUND ON HARNESS UNDER SEAT 22 AND REPAIRED.SDR DALA2015021001117Cover · damagedLIGHT COVER FELL OFF, EMERGENCY LIGHT COVER DAMAGED. REINSTALLED.SDR DALA2014090804935Wire · brokenSEAT MOUNTED EMERGENCY LIGHTS AT SEATS 1B, 2B, 3B INOPERATIVE, FOUND A BROKEN WIRE AT SEAT 1AB SEAT TRACK. REPLACED FUSE AT BATTERY PACK M730 AND REPAIRED WIRE IAW AMM 33-51 AND SWPM CH 20. LIGHTS CHECKS OK.SDR DALA2014062303685Connector · disconnectedCABIN EMERGENCY LIGHT INOPERATIVE AT FWD CABIN BULKHEAD. FOUND LIGHT ASSY CONNECTOR DISCONNECTED. RECONNECTED CONNECTORS IAW AMM 33-51. OPS CK GOOD.SDR DALA13062345651Sign · wrong partWRONG EXIT SIGN AT SEAT 24F EXIT DOOR. INSTALLED CORRECT SIGN.SDR DALA12017395651Socket · dirtyMX FOUND EXTERIOR EMERGENCY ESCAPE PATH LIGHT, INOPERATIVE ON LEFT SIDE AT AFT OVERWING & NR 3 LEFT DOOR. MX LAMPED AND CLEANED SOCKET AT NR 3. LAMPED AFT OVERWING. OPS CHECKED OK.SDR DALA12011985651Frame · damagedFUSELAGE FRAME DAMAGED AT BS 520, S-24L TO S-25L.SDR DALA12010105651Spar · damagedDURING INSPECTION OF WC 5732-01010-0430, FOUND AT RIB 25 LT AFT SPAR UPPER CHORD 4 EA EXISTING .3125" HOLES, REGULAR HOLE SIZE ARE .2500" ACCOMPLISHED PERMANENT REPAIR IAW ERA 507367-14, REV ORIGINAL ON CARD 5732-01010-0430, JOB 124-0039. ASSOCIATED ER/A 14-50SDR DALA12011975651Skin · dentedSECTION I & II DENT ON LOWER FUSELAGE RT AFT CORNER E & E DOOR CUTOUT, OUT OF LIMITS IAW SRM 53-00-01, FIG 101. PERMANENT REPAIR INSTALLED IAW ERA 507368-14, REV ORIGINAL.SDR DALA12010095651Floor Support · corrodedMID CABIN/ CENTER WING AREA, FLOORBOARD SUPPORT HAS CORROSION AT FASTENER HOLES AT F/STA 1020-1040, LBL 65 APPROX CORROSION OUT OF LIMITS AT STA 1020-1040, LBL 65. REPAIRED IAW ERA 507377-14, REV ORIGINAL ACCOMPLISHED PERMANENT REPAIR IAW ERA 507377-14, REV OSDR DALA13000295651Frame · dentedDENTS AT FRAME, BS 520 BETWEEN STR 24-25 OUT OF LIMITS. REPAIRED IAW ERA 507371-14, REV ORIGINAL. ACCOMPLISHED PERMANENT REPAIR IAW ERA 507371-14, REV.SDR DALA12009535651Floorbeam · corrodedMAIN CABIN FLOORBEAM UPPER SURFACE CORRODED STA 365.25 BL 0 -RBL 63. REMOVED CORROSION ON FLOORBEAM & FOUND TO BE OUT OF LIMITS IAW SRM 53-00-51 ALLOWABLE DAMAGE 1, PG 104, FIG 101 DETAIL III. CUTOUT UPPER FLANGE OF FLOORBEAM, FROM LBL 9.5-RBL 70 WITH CUTOUTSDR DALA12009165651Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED BS 345 BL-0, LBL-20. REMOVED CORROSION ON UPPER FLOORBEAM STA 345 BL-O LBL-20. MEASURED MAT LOSS AND FOUND OUT OF LIMITS IAW SRM 53-00-51 ALLOWABLE DAMAGE 1, PG 104, FIG 101, DETAIL III. CUTOUT UPPER FLANGE OF FLOORBEAM BS 345 FSDR DALA12010085651Deck Plate · corrodedCORROSION ON MAIN CABIN DECK PLATE FROM STA 1680-1720 BL-0 TO BL-52L. REMOVED CORROSION AT 10 EA. DIFFERENT AREAS ON AFT DECK PLATE FROM STA 1680-1720 BL0 TO BL 52L, FOUND TO BE WITH IN LIMITS IAW SRM 53-60-51, PAGE 201, FIG 201, REPAIR 2. AT THE STA 1681,SDR DALA12010075651Deck Plate · corrodedCORROSION ON MAIN CABIN DECK PLATE FROM STA 1680-1720, BL-0 TO BL-52R (AREAS MARKED). REMOVED CORROSION AT 13 EA DIFFERENCE AREAS ON AFT DECK PLATE FROM STA 1680-1720, BL 0 TO BL 52R, AND FOUND TO BE WITHIN LIMITS IAW SRM 53-60-51, PAGE 201 FIG 201, REPAIR 2SDR DALA12009545651Floorbeam · corrodedCORROSION ON MAIN CABIN FLOORBEAM AT BS 1640 LBL 3 TO RBL 3. REMOVED CORROSION AT MAIN CABIN FLOORBEAM & FOUND OUT OF LIMITS IN REF SRM 53-00-51 ALLOWABLE DAMAGE 1, FIG 101. REPAIRED UPPER TEE IN REF SRM 53-00-51, REPAIR 3. COMPLETED INSPECTED.SDR DALA12010045651Frame · dentedDENT ON FUSELAGE FRAME AT AFT CARGO COMPARTMENT ST 1500, BETWEEN STRINGER 25L AND 26L. REMOVED PRODUCTION SPLICE AND 2EA STRINGER CLIPS AT STA 1500, STR. 25-26L IAW SRM 51-40-02, PG 31, FIG 8. CUT OUT DAMAGE ON FRAME 0.9" X 1" AT STA 1500 IAW SRM 53-00-07. SDR DALA12010035651Frame · dentedDENT FUSELAGE FRAME AT AFT CARGO COMPARTMENT STA 1400 ABOVE STRINGER 26L. CUT OUT DAMAGED ON FRAME AT STA 1400 ABOVE STR 26 LT. FABRICATED REPAIR ANGLE IAW SRM 53-00-07. REPAIR 5, FIG 201. HEATED REPAIR ANGLE TREATED AND PRIME AND DRILLED AND INSTALLED REPSDR DALA12010115651Frame · dentedFWD CARGO LT STA 580, BETWEEN STR 24-25L FRAME UPPER FLANGE IS DENTED 77-10. REMOVED TRANSITION PANEL ACCESS IAW SRM 51-40-02, PG 31 TRANSITION PANEL WILL BE REINSTALLED. REMOVED PRODUTION SPLICE STA 580 BETWEEN STR24-25 LT & REMOVED STRINGER CLIP AT STA 580SDR DALA12010065651Frame · dentedFWD CARGO LT STA 600 BETWEEN STR 24-25L FRAME UPPER FLANGE IS DENTED. REMOVED PRODUCTION SPLICE STA 600 BETWEEN STR 25-26L, REMOVED SHEAR TIE, STA 600 BETWEEN STR 23L-24L REF SRM 51-40-02, PG 31. CUT OUT DAMAGE AREA AT FRAME UPPER FLANGE STA 600 BETWEEN STR 2SDR DALA12010055651Frame · dentedFWD CARGO LT STA 620 BETW STR 24-25L FRAME UPPER FLANGE IS DENTED. REMOVED PRODUCTION SPLICE, STA 630 BETWEEN STR 25 & 26 LT. REMOVED STRINGER CLIP, STR 24 LT AND SHEAR TIE BETWEEN STR 23 & 24 IAW SRM 51-40-02, PG 31. CUT OUT DAMAGED ON UPPER FRAME L. 800 WSDR DALA1204045651Wire · brokenDURING SERVICE CHECK MAINTENANCE FOUND EMERGENCY PATH LIGHT AT SEAT 28C & LEFT AFT LAV WALL INOP. MAINTENANCE REPAIRED BROKEN WIRES UNDER SEAT 28ABC AND LEFT AFT LAV WALL. OPERATION OF LIGHTS NOW CHECK OK.SDR DALA1159375651Light · inoperativeDURING MAINTENANCE LINE INSPECTION, SEAT 24C EMERGENCY LIGHT WAS FOUND INOPERATIVE. MAINTENANCE REPLACED LIGHT ASSEMBLY. SYSTEM OPERATION NORMAL AFTER REPLACEMENT.
Back to N551NW