N7887A
Service difficulty reports · 231
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 = 'N7887A' 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 = 'N7887A' 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 SWAA2021111531182None · corrodedLH TRANSITION ANGLE HAS CORROSION AROUND FASTENER HOLE UPPER SURFACE AT STA 747+2 ; / [01] COMPLIED WITH TOOL REQUIREMENT.; [02] REMOVED SURFACE CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-60-51-1A-1. REMOVE AND REPLACE ANGLE ON TASK CARD 5360-E-16462-NG (CSDR SWAA2021102031168None · corrodedLH TRANSITION ANGLE HAS CORROSION AROUND FASTENER HOLE UPPER SURFACE AT STA 747+14. REMOVED SURFACE CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-60-51-1A-1. REMOVED AND REPLACED ANGLE ON TASK CARD 5360-E-16462-NG.SDR SWAA2021102031183None · corrodedLH TRANSITION ANGLE HAS CORROSION AROUND FASTENER HOLE UPPER SURFACE AT STA 747+10. REMOVED SURFACE CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-60-51-1A-1. REMOVED AND REPLACED ANGLE ON TASK CARD 5360-E-16462-NG.SDR SWAA2021111529960None · looseLH WING FLAP DEFLECTION CONTROL RIB UPPER PANEL SUPPORT BRACKET HAS LOOSE/ELONGATED FASTENERS ; / [01] CUT OUT DAMAGE IN CONTROL RIB UPPER TAB IAW SRM 57-51-02-2R-4. CUT OUT DAMAGE IN FIXED TRAILING EDGE SUPPORT BEAM IAW SRM 57-51-02-2R-1.; [02] INSPECTED WORKSDR SWAA2021111529959None · crackedJUST OTBD OF PANEL 651DB; THE WAFFLE PLATE HAS A CRACK NEAR THE OTBD ATTACH FASTENER. ; / [01] REPLACED WAFFLE PLATE PER SRM 51-40-02; [02] VERIFIED REPLACEMENT OF WAFFLE PLATE PER SRM 51-40-02SDR SWAA2021111529961None · crackedLH WING REAR SPAR LOWER PANEL WAFFLE PLATE CRACKED JUST IB OF #3 FLAP TRACK (MARKED) ; / [01] REMOVED AND INSTALLED NEW WAFFLE PLATE PER. SRM 51-40-02-0G-0-A00729; [02] C/W INSPECTIONSDR SWAA2021111529925Panel · crackedLEFT WING PANEL 561AB 24 SCREW HOLES CRACKED TRAINING EDGE SEAL RETAINER ; / [01] REMOVED DAMAGE PER SRM 51-70-05-2R-9; [02] C/W STEP 1.; [03] APPLIED RESIN AND CHOPPED FIBERS TO DAMAGED FASTENER HOLES PER SRM 51-70-05-2R-9.; [04] INSPECTED WORK PERFORMED ON CSDR SWAA2021111529926Panel · crackedLEFT WING PANEL 561BB 31 SCREW HOLES CRACKED TRAINING EDGE SEAL RETAINER ; / [01] C; [02] REMOVED DAMAGE PER SRM 51-70-05-2R-9; [03] INSPECTED WORK PERFORMED ON C/A #2; [04] APPLIED RESIN AND CHOPPED FIBERS TO DAMAGED FASTENER HOLES PER SRM 51-70-05-2R-9.; [05SDR SWAA2021111529927Panel · crackedLEFT WING PANEL 561CB 28 SCREW HOLES CRACKED TRAINING EDGE SEAL RETAINER ; / [01] C/W DAMAGE REMOVAL PER SRM 51-70-05-2R-9; [02] C/W DAMAGE REMOVAL PER SRM 51-70-05-2R-9; [03] APPLIED RESIN AND CHOPPED FIBERS TO DAMAGED FASTENER HOLES PER SRM 51-70-05-2R-9.; [SDR SWAA2021090713813Processor · inoperativeCENTER TANK FUEL QUANTITY INDICATION INOP IN CRUISE. ; / [01] OK TO CONTINUE PER MEL 28-7-01. SP1; SP3; SP28; [02] REMOVED AND REPLACED FUEL QUANTITY PROCESSOR UNIT PER AMM 28-41-81. OPS CHECK GOOD. THIS CLEARS MEL 28-7-01. REF LOGPAGE# 1825844.SDR SWAA2021060178400Battery · weakFLAH LIGHT BATTERIES WEAK ; / REMOVED AND REPLACED AFT FLASHLIGHT BATTERYSDR SWAA2020052179633Light · inoperativeAFT ENTRY EMERGENCY LIGHT INOP / RELAMPED PER AMM 33-51-04. OPS CK GOODSDR SWAA2020052179632Battery Pack · dischargedLEFT OVERWING EMERGENCY EXIT LIGHT INOP / R&R BATTERY PACK PER AMM 33-51-06 OPS CHECK GOODSDR SWAA2020041742986Light · inoperativeCAPTAIN SIDE EMERGENCY LIGHT BY HORIZONTAL STAB INOP / R/R CAPTAIN SIDE EMERGENCY LIGHT BY HORIZONTAL STAB IAW AMM 33-51-04.SDR SWAA2020030942240Glowstrip · loosePHOTOLUMINISCENT FLOOR STRIP LOOSE AT 8C REINSTALLED PHOTOLUMIESCENT AS REQUIRED PER FIM 25-99 TASK 801SDR SWAA2019101437790Battery Pack · inoperativeEMERGENCY EXIT LIGHTS FROM M1669 DO NOT LIGHT UP. R&R BATTERY PER AMM.SDR SWAA2019101437789Battery Pack · inoperativeEMERGENCY EXIT LIGHTS FROM M1670 DO NOT LIGHT UP. R&R BATTERY PACK PER AMM.SDR SWAA2019101437788Battery Pack · inoperativeEMERGENCY EXIT LIGHTS THAT ARE FROM M1673 DO NOT WORK. / R&R BATTERY PACK PER AMM.SDR SWAA2019101437787Battery Pack · inoperativeEMERGENCY EXIT LIGHTS THAT ARE FROM M1672 DO NOT WORK. R&R BATTERY PER AMM.SDR SWAA2019101437786Light · inoperativeFORWARD ENTRY DOOR ESCAPE SLIDE EMERGENCY EXIT LIGHT DOES NOT WORK. RELAMPED LIGHT PER AMM.SDR SWAA2019101437785Battery Pack · inoperativeEMERGENCY EXIT LIGHTS THAT ARE FROM M1675 DO NOT WORK. R&R BATTERY PACK PER AMM.SDR SWAA2019093037357Angle · crackedFRAME COMMON TO CLIP ANGLE CRACKED AT BS. 294, RBL 53. / REPAIRED CLIP IAW SRM.SDR SWAA2022032128656Retainer · crackedRT WING #6 CANOE FAIRING O/B FWD BULB SEAL RETAINER IS CRACKED. / REMOVED AND REPLACED RT WING #6 CANOE FAIRING O/B FWD BULB SEAL RETAINER IAW SOPM 20-50-01 84036U 01OCT19SDR SWAA2022032928652Panel · crackedBRAKE PANEL AT STA 540; BL0-RBL 25 IS CRACKED. / REMOVED DAMAGED BRAKE PANEL AT STA 540; BLO-RBL 25 AND INSTALLED NEW ONE IAW SRM 51-40-02-0G-0 & DWG 143A0060SDR SWAA2019093037356Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS. 500D TO BS. 520, BL 0. / R&R FLANGE IAW SRM & DWG.SDR SWAA2019093037355Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS. 380 TO BS. 400, RBL 8. / R&R UPPER FLANGE IAW SRM & DWG.SDR SWAA2019093037354Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS. 380 TO BS. 400, LBL 1. / R&R UPPER FLANGE IAW SRM & DWG.SDR SWAA2019093037353Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS. 380 TO BS. 400, LBL 14. / R&R UPPER FLANGE IAW SRM & DWG.SDR SWAA2019100837680Stiffener · crackedRIGHT HORIZONTAL STABILIZER RIB AT STAB. STA. 92.70, 3RD VERTICAL STIFFENER CRACKED. REPAIRED STIFFENER IAW SRM.SDR SWAA2019100837679Stiffener · crackedL/H HORIZONTAL STABILIZER RIB AT STAB. STA. 120.30, 4TH VERTICAL STIFFENER CRACKED. REPAIRED STIFFENER IAW SRM & DWG.SDR SWAA2019093037352Seat Track · corrodedSEAT TRACK CROWN CORRODED BETWEEN BS. 727B TO BS. 887, RBL 45. / R&R SEAT TRACK IAW SRM AND DWG.SDR SWAA2019093037351Seat Track · corrodedSEAT TRACK CROWN CORRODED BETWEEN BS. 727B TO BS. 887, RBL 25. / R&R SEAT TRACK IAW SRM AND DWG.SDR SWAA2019093037350Seat Track · corrodedSEAT TRACK CROWN CORRODED BETWEEN BS. 400 TO BS. 520, RBL 25. / R&R SEAT TRACK IAW SRM AN DWGSDR SWAA2022032928571Vapor Barrier · crackedREINFORCEMENT DOUBLER ON THE FWD SIDE OF THE L/H BS663 LOWER VAPOR BARRIER IS CRACKED LBL20 WL154 / FORMED CHEMICAL CONVERSION COATED AND PRIMERED NEW REINFORCEMENT DOUBLER L/H BS. 663 LOWER VAPOR BARRIER LBL20 WL154 IAW DWG 111A1511; MM 51-21-72-370-804; MM 5SDR SWAA2022032928577Retainer · crackedLT WING UPPER T/E PANEL JUST AFT OF #1 PYLON HORIZ. SEAL RETAINER IS CRACKED. / REMOVED AND REPLACED LEFT WING UPPER T/E PANEL AFT OF #1 PYLON HORIZONTAL RETAINER IAW SRM 51-40-02-0G-0 84036U 23SEP19SDR SWAA2022032928579Angle · crackedRT WING UPPER T/E PANEL JUST AFT OF #2 PYLON O/B ATTACH ANGLE FOR THE WEB TO DEFLECTIO N RIB IS CRACKED. / REMOVED ATTACH ANGLE IAW SRM 51-40-02-0G 89813U 09-22-19 REPLACED ATTACHED ANGLE COMMON TO THE WEB TO DEFLECTION RIB AT RT WING. UPPER T/E PANEL OFF OF #SDR SWAA2022032928584Floor Panel · brokenAFT CABIN FLOOR PANEL 242XF IS BROKEN / PANEL 242XF WAS REPLACED WITH A SERVICEABLE FLOOR PANEL DUE TO AMOUNT OF ALL DAMAGE IAW SRM 51-10-02-0G-0 PARA 9.4.(1). 59702U 09/12/19SDR SWAA2022032928593Panel · damagedPANEL 193AL HAS DELAMINATIONS & PUNCTURE ON THE INNER SURFACE OF THE CORE AREA. / REPAIRED DELAMINATION AND PUNCTURE ON PANEL 193AL ON THE INNER SURFACE OF THE CORE AREA PER SRM 51-70-05-2R-2 AND SRM 51-70-05-2R-0 AND ER 19-04879 REV IR & EA 1-753-35703 REV IRSDR SWAA2019093037429Floor Panel · damagedFORWARD CABIN FLOOR PANEL 222DF UPPER SURFACE PLIES DAMAGED BETWEEN BS. 270 TO BS. 420. / REPAIRED FLOOR PANEL 222DF IAW SRM.SDR SWAA2019093037428Floor Panel · damagedFORWARD CABIN FLOOR PANEL 222CF UPPER SURFACE PLIES DAMAGED BETWEEN BS. 270 TO BS. 420. / REPAIRED FLOOR PANEL 222CF IAW SRM.SDR SWAA2019093037427Floor Panel · brokenFORWARD CABIN FLOOR PANEL 221GF FORWARD OUTBOARD CORNER BROKEN, BETWEEN BS. 270 TO BS. 420. / REPAIRED FLOOR PANEL 221GF IAW SRM.SDR SWAA2019093037347Floor Panel · damagedFORWARD CABIN FLOOR PANEL 221CF UPPER SURFACE PLIES DAMAGED BETWEEN BS. 270 TO BS. 420. / REPAIRED FLOOR PANEL 221CF IAW SRM.SDR SWAA2019100337532Floor Support · crackedINTERCOSTAL CRACKED BETWEEN BS. 312 TO BS. 328, LBL 45. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2019100337531Floor Support · crackedINTERCOSTAL CRACKED BETWEEN BS. 277 TO BS. 294, RBL 1. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2019093037345Frame · damagedFRAME DAMAGED AT BS. 277, BETWEEN BL 0 TO RBL 9. / REPAIRED FRAME IAW SRM.SDR SWAA2019093037343Door Sill · crackedL1 DOOR MOP SILL CRACKED AT BS. 303, LBL 54. / R&R MOPSILL IAW SRM AND DWG.SDR SWAA2019093037342Door Sill · corrodedR2 DOOR MOP SILL CORRODED BETWEEN BS. 967 TO BS. 986, RBL 53. / R&R MOPSILL IAW SRM AND DWG.SDR SWAA2019101437784Skin · dentedDENT ON FUSELAGE SKIN BS 391, 3" BELOW STR15L IS CREASED. / REPAIRED SKIN PER ER AND SWA EA.SDR SWAA2019100837678Lens · discoloredFORWARD ENTRY CEILING EXIT LIGHT LENS DISCOLORED. R&R LENS IAW AMM.SDR SWAA2019100337551Lens · discoloredR1 DOOR EXIT LIGHT LENS DISCOLORED. R&R LENS IAW AMM.
Back to N7887A