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 SWAA2019100337530Lens · discoloredAFT ENTRY CEILING CENTER EXIT LIGHT LENS DISCOLORED. R&R LENS IAW AMM.SDR SWAA2019100337529Lens · discoloredL1 DOOR EXIT LIGHT LENS DISCOLORED. R&R LENS IAW AMM.SDR SWAA2022031628542Gusset · crackedFWD CARGO BAY; BULKHEAD GUSSET IS CRACKED AT BS500D STR19R / REMOVED AND REPLACED FWD CARGO BAY BULKHEAD GUSSET @ BS 500D STR19R IAW SRM 51-40-02; SRM 51-40-05 AND DWG 143A7902SDR SWAA2019100337528Support · corrodedAFT CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT PLATE CORRODED BETWEEN BS. 727 TO BS. 767, RBL 22. R&R SUPPORT IAW SRM & DWG.SDR SWAA2019093037340Cargo Track · crackedAFT CARGO BAY, R/H CARGO TIE DOWN TRACK CRACKED IN THE SADDLE BETWEEN BS. 727E TO BS. 767, RBL 13. / R&R TIE DOWN TRACK PER SRM & DWG.SDR SWAA2019093037339Shield · corrodedAFT CARGO BAY SHIELD FORWARD OF CARGO DOOR CORRODED BETWEEN BS. 767 TO BS. 794, RBL 23. / R&R SHIELD IAW SRM & DWG.SDR SWAA2019093037338Support Plate · corrodedAFT CARGO BAY L/H FLOOR TO SIDEWALL SUPPORT PLATE CORRODED BETWEEN BS. 727 TO BS. 847, LBL 22. / R&R SUPPORT IAW SRM & DWG.SDR SWAA2019093037337Stiffener · corrodedAFT CARGO BAY ON FORWARD STIFFENER ON WATER SERVICE PAN CORRODED AT BS. 914, LBL 12. / R&R STIFFENER IAW SRM & DWG.SDR SWAA2019093037336Gusset · crackedFORWARD CARGO BAY, BULKHEAD GUSSET CRACKED AT BS. 500D, STR. 19L. / R&R GUSSET IAW SRM AND DWG.SDR SWAA2019062434103Screw · looseL/H OVERWING EMERGENCY EXIT DOOR SCREW CAME OUT. REINSTALLED SCREW PER SIP.SDR SWAA2018121827706Water Separator · dirtyAIR TURNBACK/DECLARED EMERGENCY, STRONGER ODOR DURING CLIMB. WORSE IN THE CABIN. R&R WATER SEPARATORS PER AMM.SDR SWAA2018121827705Coalescer Bag · dirtyAIR TURNBACK/DECLARED EMERGENCY, STRONGER ODOR DURING CLIMB. WORSE IN THE CABIN. R&R COALESCER BAG PER AMM.SDR SWAA2018091725234Vapor Barrier · crackedRT MAIN LANDING GEAR WHEEL WELL VAPOR BARRIER CRACKED BETWEEN RBL 54.21 TO RBL 40.0. REPAIRED BARRIER PER EA.SDR SWAA2018032620671Lens · looseLEFT OVERWING EMERGENCY LIGHT LENS LOOSE. R & R THE LENS IAW SIP.SDR SWAA2018020819524Light · faultyEMERGENCY EXIT LIGHT FAULTY. R & R THE LIGHT IAW AMM.SDR SWAA2018020819532Slide · low pressureR1 DOOR EMERGENCY ESCAPE SLIDE GAUGE INDICATED LOW PRESSURE. R & R THE SLIDE IAW MT.SDR SWAA2018013019438Light · inoperativeRT OVERWING EMERGENCY EXIT LIGHT INOP. R&R BULB PER AMM.SDR SWAA2018012919367Light · inoperativeEMERGENCY LIGHT LAMP INOP AT BS 757, RBL 51. R&R LAMP IAW AMM.SDR SWAA2018012419304Scuff Plate · crackedFORWARD CARGO DOORWAY FORWARD CORNER SCUFF PLATE CRACKED. REPAIRED SCUFF PLATE IAW EA.SDR SWAA2018012219232Scuff Plate · crackedFORWARD CARGO DOORWAY AFT CORNER SCUFF PLATE CRACKED. REPAIRED SCUFF PLATE IAW EA.SDR SWAA2022020728484Bracket · brokenR/W T/E PANEL 651FB HAS A BROKEN BRACKET ON FWD SIDE 3RD FROM O/B END / REMOVED AND INSTALLED NEW R/W T/E PANEL 651FB BRACKET ON FWD SIDE 3RD FROM O/B END IAW SRM 51-40-02 REFERANCED IPC 57-50-00-38 FOR FASTENER CALLOUT. 13038U 29DEC17SDR SWAA2022020728478Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 241NF UPPER SURFACE IS DELAMINATED / PASSENGER CABIN FLOOR PANEL 241NF WAS FABRICATED IAW SRM 53-00-50-2R-0 AND BOEING DWG 146A5810-6 56144U 12/27/2017SDR SWAA2022020728479Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 241RF UPPER SURFACE IS DELAMINATED / DO TO THE EXTENT OF UPPER SURFACE DAMAGE FABRICATED NEW FLOOR PANEL PER SRM 53-00-50-2R-0 AND DWG 146A5810-11SDR SWAA2022020728480Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 241UF UPPER SURFACE IS DELAMINATED / FABRICATED NEW PANEL 241UF IAW SRM 53-00-50-2R-0 PARA 1 NOTE; USING BMS 4-17 TY 6 LOT # 212012/1 IAW SRM 53-00-50-2R-0 TABLE 204. LOCATED; DRILLED; & INSTALLED INSERTS USING BMS 5-107 LOT# AK7GP4SDR SWAA2022020128469Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 231AF UPPER SURFACE IS DELAMINATED / DAMAGED FLOOR PANEL 231 AF WAS REPLACED WITH A SERVICABLE PART IAW SRM 51-10-02-0G-0 PAR 9SDR SWAA2022020128470Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 231DF UPPER SURFACE IS DELAMINATED / FABRICATED NEW PANEL 231DF IAW SRM 53-00-50-2R-0 PARA 1 NOTE USING BMS4-17 TY6 LOT # 212012/1 IAW SRM 53-00-50-2R-0 TABLE 204. LOCATED; DRILLED; & INSTALLED INSERTS USING BMS 5-107 LOT # AK7GP494SDR SWAA2022020128471Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 231GF UPPER SURFACE IS DELAMINATED / FABRICATED NEW PANEL 231 GF IAW SRM 53.00.50.2R.0 & DWG 143A5810-10 57252U 12/28/17.SDR SWAA2022020128472Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 231KF UPPER SURFACE IS DELAMINATED / FABRICATED NEW PANEL 231KF IAW SRM 53-00-50-2R-0 PARA 1 NOTE; USING BMS 4-17 TY6 LOT# 212012/1 IAW SRM 53-00-50-2R-0 TABLE 204. LOCATED; DRILLED; & INSTALLED INSERTS USING BMS 5-107 LOT # AK7GP49SDR SWAA2022020128473Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 231UF UPPER SURFACE IS DELAMINATED / FABRICATED NEW PASSENGER CABIN FLOOR BOARD PANEL #231UF IAW SRM 53-00-50-2R-0 PARA 4A (NOTE) AND DWG 143A5810-109 20549U 12/28/17SDR SWAA2022020128474Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 231XF UPPER SURFACE IS DELAMINATED / FABRICATED NEW PASSENGER CABIN FLOOR PANEL #231XF PER DWG 144A 5810-126 20549U 12/28/17 AND SRM 53-00-50-2R-0 PARA 1A (NOTE) 20549U 12/28/17SDR SWAA2022020128475Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 241AF UPPER SURFACE IS DELAMINATED / PASSENGER CABIN FLOOR PANEL 241AF WITH UPPER SURFACE DELAMINATION WAS REPLACED WITH A NEW PANEL IAW SRM 53-10-50-2R-0 2ND DWG 144A5810.SDR SWAA2022020128476Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 241DF UPPER SURFACE IS DELAMINATED / FABRICATED NEW PANEL 241DF USING BMS 4-223 TV2 LOT # 1301132-1 IAW SRM 53-00-50-2R-0 PARA 4 TABLE 204. LOCATED; DRILLED & INSTALLED INSERTS USING BMS5-107 LOT # AK7GP4949K & PART MARKED IAW DWG 1SDR SWAA2022020128477Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 241KF UPPER SURFACE IS DELAMINATED / PASSENGER CABIN FLOOR PANEL 241KF WAS FABRICATED IAW SRM 53-00-50-2R-0 AND BOEING DWG 146A5810-53 56144U. 12/27/2017SDR SWAA2022020728468Fairing · delaminated#6 FLAP TRACK FAIRING TAILCONE HAS A DISBOND ON THE I/B LOWER OUTER SURFACE 4.7' FROM THE LEADING EDGE / DISBOND ON I/B LOWER OUTER SURFACE OF #6 FLAPTRACK FAIRING TAILCONE REPAIRED IAW SRM 51-70-04-2R-2 57443U 23DEC17SDR SWAA2018012219231Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 500 TO BS 500A, STR 25L. R&R INTERCOSTAL IAW SRM.SDR SWAA2018011719074Web · corrodedAFT CARGO LOWER MAIN DOOR SILL WEB CORRODED AT BS 794, STRINGER 25R. R & R THE WEB IAW SRM & DWG.SDR SWAA2018011719090Strap · damagedRIGHT EMERGENCY EXIT HATCH ESCAPE STRAP UNSERVICEABLE. R & R THE HATCH STRAP IAW AMM.SDR SWAA2018011719089Strap · damagedLEFT EMERGENCY EXIT HATCH ESCAPE STRAP UNSERVICEABLE. R & R THE HATCH STRAP IAW AMM.SDR SWAA2022020428451Floor Panel · corroded***CORROSION*** AFT CARGO BAY PANEL 140BF HAS CORROSION ON BOTTOM SURFACE. / VERIFIED APPLICABILITY AND FOUND CORROSION WAS BEYOND ALLOWABLE LIMITS PER SRM 57-40-08-0G-0. FABRICATED NEW PANEL FROM 2024T3 .071; LOT # 1310914-1 PER DWG 453A2610 AND SRM 57-40-08-SDR SWAA2018012519317Skin · crackedLOWER BULKHEAD SKIN CHORD CRACKED AT BS 540, STR 22R. REPAIRED SKIN PER ER & EA.SDR SWAA2022020428447Rib · elongatedLT HORIZONTAL STAB RIB; 1 EA ELONGATED HOLE; AT STAB STA 111.10 LWR CHORD; OB FLANGE; 19TH HOLE FROM FRONT SPAR; MARKED / HOLE AT STAB STATION 111.10 WAS STEPPED UP TO 0.196 IAW ACO 723031 STEP 4.B.(3).(D)-(E) HOLE IS NO LONGER ELONGATEDSDR SWAA2022020428448Rib · elongatedLT HORIZONTAL STAB RIB; 1 EA ELONGATED HOLE; AT STAB STA 111.10 LWR CHORD; OB FLANGE; 26TH HOLE FROM FRONT SPAR; MARKED / HOLE AT STAB STATION 111.10 WAS STEPPED UP TO 0.196 IAW ACO 723031 STEP 4. B. (3). (D) - (E) HOLE IS NO LONGER ELONGATED.SDR SWAA2022020428449Rib · elongatedLT HORIZONTAL STAB RIB; 1 EA ELONGATED HOLE; AT STAB STA 101.90 LWR CHORD; OB FLANGE; 10TH HOLE FROM REAR SPAR; MARKED / HOLE AT STAB STATION 101.90 WAS STEPPED UP TO 0.196 IAW ACO 723031 STEP 4. B. (3). (D) - (E) HOLE IS NO LONGER ELONGATEDSDR SWAA2018012319270Rib · crackedRT HORIZONTAL STABILIZER INSPAR RIB CRACKED AT 2ND VERTICAL STIFFENER AT STA 92.7. REPAIRED RIB IAW SRM.SDR SWAA2018012219230Rib · crackedRT HORIZONTAL STAB INSPAR RIB CRACKED AT 1ST VERTICAL STIFFENER AT STA 92.7. REPAIRED RIB IAW SRM.SDR SWAA2018012219229Stiffener · crackedLT HORIZONTAL STABILIZER INSPAR RIB 2ND VERTICAL STIFFENER CRACKED AT STA 120.3. R&R STIFFENER IAW SRM.SDR SWAA2018011819105Stiffener · crackedLEFT HORIZONTAL IN SPAR RIB THIRD VERTICAL STIFFENER CRACKED AT HSS 120.3. R & R STIFFENER IAW SRM.SDR SWAA2022020428442Seal · crackedRT STAB FWD UPPER SLIDE SEAL CRACKED / REMOVED AND REPLACED RT STAB FWD UPPER SLIDE SEAL IAW AMM 53-31-31-000-802 & 53-31-31-400-802 56790U 27DEC17SDR SWAA2022020428443Seal · crackedLT HORIZONTAL STAB FWD UPPER SLIDE SEAL CRACKED / REMOVED AND REPLACED LT STAB FWD UPPER SLIDE SEAL IAW AMM 53-31-31-000-802 & 53-31-31-400-802 56790U 27DEC17SDR SWAA2022020428438Bracket · crackedAFT CARGO BAY CRACKED STATION BRACKET AT BS 867 LBL 10 WL 165 / REMOVED AND INSTALLED STATION BRACKET AT AFT CARGO BAY BS867 LBL 10 WL 165 IAW SRM 51-40-02-0G-0; DWG 149A8104 ID: 0001 REV B. 92954U 12/14/17
Back to N7887A