N553NW
Service difficulty reports · 140
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 = 'N553NW' 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 = 'N553NW' 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 DALA12015885653Frame · dentedDURING MX CHECK, DENTS WERE FOUND IN THE BS 540 FRAME BETWEEN S-24L AND S-25L. DENTS REPAIRED IAW ER/A 508335- DTA MONITOR INSPECTION LOG REF EA508335-14. REPAIR APPROVED FOR 24 MONTHS FROM 07 DEC 2012.SDR DALA12015875653Frame · dentedDURING MX, DENTS WERE FOUND IN THE BS 600 FRAME BETWEEN S-22L AND S-25L. DENTS WERE REPAIRED IAW ER/A 508941-14.SDR DALA12015595653Floor Support · corrodedMAIN CABIN FLOOR STRUCTURE, FLOOR SUPPORT IS CORRODED AT UPPER SURFACE, BS 365, BL 0 FOUND CORROSION IN VARIOUS PLACES. FOUND OUT OF LIMITS, R & R FLOOR SUPPORT BS 324 TO 418 BL 0 IAW SRM B757-200-57-40-02 PG 4SDR DALA12015585653Structure · corrodedLAVATORY "A" CONNECTION BOX INSIDE E&E COMPARTMENT ZONE 119 HAS CORROSION AROUND WASTE DRAIN PIPE CONNECTION. FOUND SUPPORT LAV "A" CONNECTION BOX AND DOUBLER OUT OF LIMITS IAW SRM 53-00-01 ALLOW DAMAGE 1 FIGURE 101 PG 104. RECEIVED AND INSTALLED NEW PARTS,SDR DALA12015865653Shear Tie · misrepairedHORIZONTAL STAB COMP FRAME, SHEAR TIE EXISTING RIVET AND PREVIOUS REPAIR RIVET HAS ZERO PITCH AND EDGE DISTANCE IS OUT OF LIMITS AT STA 1844 BET S3L- S4L. : EXTERNAL SKIN HAS PREVIOUS REPAIR DOUBLER INSTALLED. ACCOMPLISHED REPAIR IAW ER/A 508957-14, REV ORSDR DALA12014715653Seat Track · corrodedMAIN CABIN SEAT TRACK IS CORRODED AT OTBD FLANGE UPPER SURFACE, RBL 45.5 BETWEEN BS 720 AND 780. R & R SEAT TRACK IAW SRM 51-40-02, PG7: TSDR DALA12014745653Floor Support · corrodedCORROSION ON AFT CARGO FLOOR SUPPORT UNDER NUT PLATE AT BS 1510. LBL 2.90. REMOVED CORROSION IAW SRM 53-00-53, FIG 101. ORIGINAL MATERIAL THICKNESS IS .063" IAW SRM 53-60-53, FIG 1. REMAINING MATERIAL IS .049" IAW NDTM PT6, 51-00-11, NO CRACK NOTED AT BLESDR DALA12014685653Floor Support · corrodedCORROSION ON AFT CARGO FLOOR SUPPORT ON TOP AND UNDER NUT PLATES AT BS 1470 RBL 7.55. FOUND OUT OF LIMITS IAW SRM 53-00-53, FIG 101, SHEET 4&5. REMOVED DAMAGED SECTION FLOOR SUPPORT BETWEEN BS 1445-1505, IAW SRM 51-40-02, PG 7 & 31. CUT OUT DAMAGE ON UPPER SDR DALA12013785653Floorbeam · corrodedFLOORBEAM CORRODED AT UPPER AND LOWER SURFACE, BS 365 AND BETWEEN BL 0 AND RBL 60. REMOVED CORROSION ON FLOORBEAM AND FOUND OUT OF LIMITS IAW SRM 53-00- 51 PG 104 FIG 101 DETAIL III AND REPAIRED IAW SRM 53-00-51, FIG 201, PAGE 201-206, REP 3.SDR DALA12013775653Floor Support · corrodedMAIN CABIN FLOOR STRUCTURE IS CORRODED AT UPPER SURFACE, RBL 65 BETWEEN STA 760 AND 780. R & R INTERCHORD IAW SRM 51-40-02, PAGE 7 AT MAIN CABIN STA 760-890, RBL 65.SDR DALA12014705653Frame · dentedAFT CARGO COMPARTMENT FRAME IS DENTED AT UPPER SURFACE AT BS 1480, S23 AND 26L. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07, REPAIR 5, FIG 201. THIS IS A CATEGORY B REPAIR.SDR DALA12014695653Frame · dentedAFT CARGO COMPARTMENT, FRAME IS DENTED AT UPPER SURFACE AT BS 1400, BETWEEN S23 AND 26L FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07-R5, FIG 201.SDR DALA12014675653Frame · dentedAFT CARGO COMPARTMENT, FRAME IS DENTED AT UPPER SURFACE AT BS 1400, BETWEEN S23 AND 26L. GAINED ACCESS, FABRICATED AND FRAME BS 1400 BETWEEN S23 AND 26L.SDR DALA12013225653Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM BS 1640 FROM LBL 20 TO RBL 10. REPAIRED FLOORBEAM IAW SRM 53-00-51, FIG 201, REPAIR 3.SDR DALA12013475653Floorbeam · corrodedMAIN CABIN FLOORBEAM IS CORRODED AT UPPER SURFACE, BS 377 BETWEEN RBL 13 & LBL 24. REMOVED CORROSION ON MAIN CABIN FLOORBEAM UPPER SURFACE, FOUND ONE AREA OUT OF LIMITS. REPAIRED IAW ERA 481634-14MA REV ORIG.SDR DALA11000065653Skin · damagedLT LOWER WING SKIN DAMAGE, WS 205 AND S10L.SDR DALA1237985653Socket · dirtyDURING EMERGENCY LIGHT CHECK, FOUND R4 DOOR EXTERIOR LIGHT NOT ILLUMINATED. CLEANED LAMP SOCKET AND LAMPED. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR DALA1230835653Charger · failedDURING INSPECTION DISCOVERED THE OVERWING EMERGENCY EXIT THRESHOLD LIGHTS INOPERATIVE, RT SIDE AFT DOOR AFT LIGHT, LT SIDE FWD DOOR AFT LIGHT AND LT SIDE AFT DOOR FWD LIGHT. FOUND BAD CHARGER AND REPLACED, OPS CHECKED NORMAL.SDR DALA1210005653Floor Support · damagedWHILE WORKING EA 500029-14, MAINTENANCE FOUND DAMAGE TO FLOOR SUPPORT IN FORWARD CARGO FLOOR RBL 2.9 APPROX STATION 660. FLOOR SUPPORT WAS REPAIRED PER SRM 53-00-53.SDR DALA1164245653Skin · damagedER/A 497012-14 FOR LT LOWER WING SKIN DAMAGE, WSTA 205 AND S-L10. THE LARGEST AREA OF DAMAGE RESULTED IN DEEP GOUGING & DENTING OF THE SKIN AND STRINGER L-11 CENTERED AROUND WSTA 205. STRINGER L-11 WAS ALSO BADLY DEFORMED. DAMAGE TOLERANCE ANALYSIS IS REQUSDR DALA1164555653Skin · damagedLEFT WING LOWER SURFACE STRINGER BENT AT WS 204. REPAIRED PER ERA 497012-14 REV ORIG.SDR DALA1164545653Skin · gougedLOWER LT WING SKIN, GOUGED, WS 250 AT STR 13. MARKED GOUGE. REPAIRED PER ERA 497012-14 REV ORIG.SDR DALA1164535653Skin · gougedLOWER LT WING SKIN, GOUGED, WS 233 AT STR 8. MARKER GOUGE. REPAIRED PER ERA 497012-14 REV ORIG.SDR DALA1164525653Skin · damagedLT WING STRINGER HAS TOOLING DAMAGE AT WS 204. BOTTOM SURFACE AT CUTOUT FOR WING SKIN DAMAGE MKD. REPAIRED PER ERA 497012-14 REV ORIG.SDR DALA1164515653Skin · gougedLOWER LT WING SKIN, GOUGED, WS 228-233, BTW STR 14 &15. MARKED GOUGED. REPAIRED PER ERA 497012-14 REV ORIG.SDR DALA1164505653Skin · gougedLOWER LT WING SKIN GOUGED WS 204-215 BTW STR 11 AND 14. MARKED GOUGED. REPAIRED PER ERA 497012-14 REV ORIG.SDR DALA1164495653Skin · gougedLOWER LT WING SKIN GOUGED WS 248 2 INCH AFT OF STR 14. MARKED GOUGED REPAIRED PER ERA 497012-14 REV ORIG.SDR DALA1164485653Skin · dentedGOUGES LT WING LOWER SKIN BETWEEN STRINGERS 9 AND 10 AT WING STA 210 MARKED GOUGE-B. DAMAGE REPAIRED PER ERA 497012-14 REV ORIG.SDR DALA1164475653Skin · dentedGOUGES - LT WING LOWER SKIN BETWEEN STRINGERS 10 AND 11 O/B OFWING STA 204.5. MARKED GOUGE-A. DAMAGE REPAIRED PER ERA 497012-14 REV ORIG.SDR DALA1164465653Skin · dentedDENT- LT WING LOWER SKIN AT STRINGER 11 WING STA 200. MARKED DENT-A DAMAGE REPAIRED PER ERA 497012-14 REV ORIG.SDR DALA1164455653Skin · dentedDENT - LT WING LOWER SKIN FWD OF STRINGER 10 WING ATA 207. MARKED DENT-B DAMAGE REPAIRED PER ERA 497012-14 REV ORIG.SDR DALA1164445653Skin · dentedLOWER LT WING SKIN GOUGED WS 200 FWD OF STR 9. MARKED GOUGE-F DAMAGE REPAIRED PER ERA 497012-14 REV ORIG.SDR DALA1164425653Skin · gougedLOWER LT WING SKIN GOUGED JUST AFT OF STR 13 AR WS 234. MARKED GOUGE C DAMAGE REPAIRED PER ERA 497012-14 REV ORIG.SDR DALA1164415653Skin · gougedLOWER LT WING SKIN IS GOUGED FWD OF STR 13 AT WS 239. MARKED GOUGED DAMAGE REPAIRED PER ERA 497012-14 REV ORIG.SDR DALA1164405653Skin · gougedLOWER WING SKIN IS GOUGED JUST FWD OF STR 12 AT WS 241. MARKED GOUGE-E DAMAGE REPAIRED PER ERA 497012-14 REV ORIG.SDR DALA1164395653Skin · dentedDENT - LT WING LOWER SKIN AFT OF STRINGER 11 AT WING STA 218 MARKED DENT. DAMAGE REPAIRED PER ERA 497012-14 REV ORIG.SDR DALA1157865653Engine · failedABORTED TAKEOFF AT APPROX 80 KNOTS DUE TO LEFT ENGINE FAILURE. MAINTENANCE REPLACED LEFT ENGINE.SDR DALA12012745653Skin · damagedLIGHTNING STRIKE DAMAGE WAS DISCOVERED. MX PERFORMED ER/A 493934-14 PERMANENT REPAIR AT BS 1640, BETWEEN S10R AND S11R.SDR NWAA073245653Engine · flamed outDURING APPROACH DESCENDING THROUGH 20,000 FT, ENGINE NR 1 FLAMED OUT. FLIGHT CREW PERFORMED AN UNEVENTFUL LANDING. MAINTENANCE REPLACED ENGINE NR 1.SDR NWAA071345653Battery Pack · inoperativeDURING A LINE CHECK, THE EMERGENCY EXIT SIGN AT DOOR 3 LEFT FOUND INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERY POWER SUPPLY IAW AMM 33-51-07, OP CHECKS GOOD. AIRCRAFT OK FOR SERVICE.
Back to N553NW