N7723E
Service difficulty reports · 270
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 = 'N7723E' 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 = 'N7723E' 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 SWAA2021081095307Web · corrodedCORROSION ON SUBTHRESHOLD WEB AT AFT CARGO BAY BS802 - BS827 RBL26 WL159. ; / [01] REMOVED CORROSION ON SUBTHRESHOLD WEB AT AFT CARGO BAY BS802-BS827 RBL26 WL159 DIMENSIONS: L=25' W=2' D=0.007' WAS FOUND OUT OF LIMIT DUE MATERIAL LOSS IS MORE THAN 10% OF THICKSDR SWAA2021081095290Web · corrodedCORROSION ON WEB AT AFT CARGO BAY BS792 RBL19 WL157. ; / [01] REMOVED CORROSION ON WEB AT AFT CARGO BAY BS 792 RBL 19 WL 157 MAX MATERIAL LOSS L=4';W=1';D=0.020 FOUND TO BE OUT OF LIMITS IAW SRM 53-60-15-1A-1 STEP 4G (2)(B) FIG 103 TOOL USED ID ATS1672 S/N 650SDR SWAA2021081095270Support · corrodedCORROSION ON FLOOR TO SIDEWALL SUPPORT AT AFT CARGO BAY BS873 - BS887 RBL21 WL169. ; / [01] REMOVED CORROSION AT FLOOR TO SIDEWALL SUPPORT AT AFT CARGO BAY BS 873 BS 887 RBL 21 WL 169 MAX MATERIAL LOSS L=5';W=2.5';D=0.006' FOUND TO BE OUT OF LIMITS IAW SRM 53-SDR SWAA2021081095253Support · corrodedCORROSION ON FWD CARGO BAY FLOOR TO SIDEWALL SUPPORT AT BS 441 TO 458 LBL 24 WL 156 ; / [01] REMOVED CORROSION ON FLOOR TO SIDEWALL SUPPORT AT BS 400+6'; LBL24; WL 156 PER SRM51-10-02-0G-0 MEASURE L=1'X W=0.75'X D=0.006' MAX. MAT LOSS IS 0.006'; REMAINING THICSDR SWAA2021081095240Stiffener · crackedRIGHT HAND HORIZONTAL STABILIZER INSPAR RIB; AT STABILIZER STATION 129.50; 3RD VERTICAL STIFFENER IS CRACKED. ; / [01] CUT 0UT AND REMOVED DAMAGED SECTION AT VERTICAL STIFFENER OF THE RIB L= .80; W=.312 STATION 129.50 3RD VERTICAL STIFFENER PER SRM 55-10-09-2RSDR SWAA2021081095239Stiffener · crackedLEFT HAND HORIZONTAL STABILIZER INSPAR RIB; AT STABILIZER STATION 129.50; 3RD VERTICAL STIFFENER IS CRACKED. ; / [01] PERFORMED CUT OUT 3RD VERTICAL STIFFENER STAB INSPAR RIB AT STA 129.50 L: .900' W: .312' IAW SRM 55-10-09-2R-4 REPAIR 4; [02] REQ NDI CUT OUT SDR SWAA2021081095229Pressure Deck · dentedFLIGHT DECK FLOOR IS DENTED AT B.S. 255; R.B.L. 4 - L.B.L. 14; W.L. 207.54. ; / [01] DAMAGED AT EXISTING REPAIR FOUND TO BE OUT OF LIMITS NO ALLOWABLE DAMAGE FOUND AT SRM; [02] ADDING SRM REFERENCE USED: SRM 53-10-51-1A-1; [03] CORRECTING MEASUREMENT FOR SHORTSDR SWAA2021081097224Skin · dentedFUSELAGE EXTERNAL SKIN HAS A DENT AT BS 500C+9'; 2.3' ABOVE STR 5R. ; / [01] REMOVED DECORATIVE EXTERIOR PAINT AT DISCREPANCY AREA TO FOM PER AMM 51-21-11; [02] EVALUATED DENT AT DISCREPANCY AREA L= 1.5' W=1.3' FOUND TO BE OUT OF LIMITS DUE TO BLEND OUT (AREA SDR SWAA2021081094322Skin · corrodedFUSELAGE EXTERNAL SKIN HAS A CORROSION AT 1089 BETWEEN STR 18LH- STR 21LH ; / [01] REMOVED PAINT AT DISCREPANCY AREA PER REF AMM 51-21-11; [02] REMOVED CORROSION AT DISCREPANCY AREA PER REF SRM 51-10-02-0G-004] ET INSPECTED BLEND/HOLES/COUNTERSINKS IAW 737 NDTSDR SWAA2021081094328Skin · corrodedFUSELAGE EXTERNAL SKIN HAS CORROSION AT BS 1089 AROUND PRIMARY JACK POINT 'C' ; / [01] REMOVED PAINT AT DISCREPANCY AREA PER REF AMM 51-21-11; [02] REMOVED CORROSION AT DISCREPANCY AREA L=3.7' W=2.7' PER SRM 51-40-02; [03] STEP 2 REFERENCE ENTRY AND ERROR. REMSDR SWAA2021081094320Skin · corrodedFUSELAGE AFT SKIN PANEL AT BUTT JOINT BS 1016 HAS CORROSION BETWEEN STR 21L - 22L ; / [01] REMOVED PAINT AT DISCREPANCY AREA PER REF AMM 51-21-11; [02] REMOVED FASTENERS AT DISCREPANCY AREA PER REF SRM 51-40-02; [03] REMOVED CORROSION AT DISCREPANCY AREA PER SSDR SWAA2021081094323Skin · corrodedFUSELAGE AFT SKIN PANEL AT BUTT JOINT BS 1016 HAS CORROSION BETWEEN STR 24L - 24R ; / [01] REMOVED PAINT AT DISCREPANCY AREA PER REF AMM 51-21-11; [02] REMOVED CORROSION AT DISCREPANCY AREA PER REF SRM 53-00-01-1A-1; [03] REMOVED 11EA FASTENERS AT BLENDED AREASDR SWAA2021081094292Skin · crackedCRACK IN #5 SLAT LOWER SKIN NEAR ACTUATOR FITTING ATTACH FASTENER ; / [01] HFEC INSPECTED CRACK ON #5 SLAT LOWER SKIN IAW 737 NDTM PART 6 51-00-00 PROCEDURE 23; AREA MARKED. EQUIP ID#: IS000450 S/N: N500D000M120071; [02] REMOVED HI LOCK AT #5 SLAT LOWER SKIN NSDR SWAA2021050769025Floor Panel · damagedAFT FLOOR PANEL 241AAF UPPER SKIN HAS AREAS OF PULLED STRANDS. /SDR SWAA2021050769024Floor Panel · damagedFWD FLOOR PANEL 222DF HAS 2 AREAS OF EDGE DAMAGE. (MARKED) /SDR SWAA2021050769023Floor Panel · damagedFWD FLOOR PANEL 222DF HAS DAMAGED INSERTS. /SDR SWAA2021050769022Floor Panel · damagedFWD FLOOR PANEL 222BF UPPER SKIN HAS AREAS OF PULLED STRANDS. /SDR SWAA2021050769021Floor Panel · damagedFWD FLOOR PANEL 221DF UPPER SKIN HAS AREAS OF PULLED STRANDS. /SDR SWAA2021050769020Floor Panel · damagedFWD FLOOR PANEL 221CF HAS DAMAGED INSERTS. /SDR SWAA2021050769019Floor Panel · damagedFWD FLOOR PANEL 221BF UPPER SKIN HAS AREAS OF PULLED STRANDS. /SDR SWAA2021050769018Floor Panel · damagedFWD FLOOR PANEL 221AF UPPER SKIN HAS AREAS OF PULLED STRANDS. /SDR SWAA2020012940859Sign · incorrectRT SIDE EMERGENCY OVERWING EXIT SIGN ARROW WAS POINTING WRONG. / INSTALLED CORRECT EXIT SIGN PER MM.SDR SWAA2020011640493Fastener · missingR1 DOOR SLIDE GIRT FLAP HUNG UP ON THRESHOLD DUE TO FASTENER MISSING. REPOSITIONED SLIDE PER MT.SDR SWAA2019122639927Slide · looseR1 DOOR ESCAPE SLIDE WAS NOT PACKED CORRECTLY. GIRT BAR WAS HANGING DOWN TO FAR. SECURED SLIDE PER MT.SDR SWAA2019122639926Girt Bar · out of adjustL2 DOOR SLIDE GIRT NEEDS REINSTALLED, TOO LONG. REATTACHED GIRT PER MT.SDR SWAA2019052132894Light · inoperativeEMERGENCY EXIT LIGHT AFT OF L1 DOOR INOP. REPAIRED EXIT LIGHT ELEC WIRING PER AMM.SDR SWAA2022030990410Strap · elongatedATS RESPONSIBILITY WHILE WORKING SEAT TRACK FOUND STRAP AT BS 867-887 RBL 45 WL 207 TO HAVE 4 EA ELONGATED FASTENER HOLES / ACCOMPLISHED HIDDEN DAMAGE INSP.; REF. SRM 51-10-02-0G-0; NO ADDTIONAL DEFECTS NOTED. INSP 107 05-06-19 LOCATED AND DRILLED REPLACMENT SSDR SWAA2022030890367Panel · delaminatedPANEL 521KB HAS DELAMINATION AT FORWARD CORNERS OF CUTOUT / PANEL 521KB WITH DELAMINATION AT FORWARD CORNERS OF CUTOUT WAS REPAIRED IAW SRM 51-70-05-2R-6. 59702U 05/09/19SDR SWAA2022030890360Bracket · crackedL/W T/E UPPER SEAL RETAINER IS CRACKED ON THE NO STEP PANEL ORSS 271. / REMOVED AND REPLACED SEAL RETAINER BRACKET ON LH T/E UPR NO STEP PANEL AT STA 271 PER SRM 51-40-02-0G-0; STEP 4;9.SDR SWAA2022022490365Strip · crackedR/W T/E WIGGLE STRIP AT ORSS 261 HAS SHEARED RIVETS AND IS CRACKED.. / REMOVED & REPLACED R/W T/E WIGGLE STRIP PER SRM 51-40-02-0G-0 STEPS 4.A.& B.SDR SWAA2019052032852Connector · damagedMID CABIN OVERHEAD EMERGENCY EXIT LOCATOR SIGN CONNECTOR D12030 DAMAGED. R&R CONNECTOR PER SWPM AND WDM.SDR SWAA2019051732778Threshold · crackedAFT CARGO BAY FORWARD CORNER THRESHOLD CRACKED. R&R THRESHOLD IAW AMM & EA.SDR SWAA2019051632736Scuff Plate · crackedFORWARD CARGO DOOR FORWARD CORNER SCUFF PLATE CRACKED. REPAIRED SCUFF PLATE IAW EA.SDR SWAA2019051632735Scuff Plate · crackedFORWARD CARGO DOOR AFT CORNER SCUFF PLATE CRACKED. REPAIRED SCUFF PLATE IAW EA.SDR SWAA2019052032851Seat Track · corrodedCABIN SEAT TRACK CORRODED BETWEEN BS. 727B TO BS. 887, RBL 45. R&R SEAT TRACK IAW SRM AND DWG.SDR SWAA2019050632309Housing · brokenR1 DOOR LOWER FORWARD EMERGENCY EXIT LIGHT HOUSING BROKEN. R&R LIGHT HOUSING IAW AMM.SDR SWAA2019031330562Slide · out of positionL1 DOOR SLIDE OUT OF POSITION IN SLIDE COMPARTMENT. REPOSITIONED SLIDE PER MT.SDR SWAA2019031330561Rivet · shearedFORWARD L1 DOOR GIRT BAR RETAINER CLIP RIVET SHEARED. R&R FASTENER IAW EA AND DWG.SDR SWAA2019022129911Light · inoperativeLT OVER WING EMERGENCY LIGHTS INOP. R&R LIGHTS IAW AMM.SDR SWAA2019022129872Light · inoperativeLT EMERGENCY LIGHTS INOP BETWEEN ROW 13 TO ROW 17 (M1670). R&R LIGHTS IAW AMM.SDR SWAA2018082024293Hydraulic Line · brokenDIVERSION, NR 1 ENGINE "LOW PRESSURE" A HYDRAULIC PUMP ILLUMINATED. R&R NR 1 ENGINE HYDRAULIC PRESSURE LINE PER AMM.SDR SWAA2022020890223Support Bracket · crackedUPPER FIXED T/E PNL AT RT WS 278.50 HAS CRACKED SUPPORT BRACKET AT DEFLECTION ROLLER SUPPORT FITTING / REMOVED AND REPLACED CRACKED SUPPORT BRACKET AT RIGHT WING STATION 278.5 PER SRM 51-40-02.SDR SWAA2018011118982Bracket · crackedRT WING UPPER FIXED TRAILING EDGE PANEL SUPPORT BRACKET CRACKED AT WING STA 278.50. R&R BRACKET PER SRM.SDR SWAA2017122918666Lens · missingL2 DOOR EXIT LIGHT LENS MISSING. REPLACED THE LENS IAW MM.SDR SWAA2017122118606Lens · missingAFT BULKHEAD EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA2017122118605Battery Pack · dischargedAFT BULKHEAD EMERGENCY EXIT LIGHT INOP. INSTALLED BATTERY PACK PER MM.SDR SWAA2017122118604Lens · missingFORWARD BULKHEAD EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA2017122118603Battery Pack · dischargedFORWARD BULKHEAD EMERGENCY EXIT LIGHT INOP. INSTALLED BATTERY PACK PER MM.SDR SWAA2017050913649Bracket · out of adjustR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR BRACKET OUT OF ADJUST. ADJUSTED BRACKET PER SIP.SDR SWAA2017042513287Crease Beam · corrodedUPPER SURFACE OF CREASE BEAM WEB CORRODED AT BS 705. R & R CREASE BEAM WEB IAW SRM AND DWG.
Back to N7723E