N7888A
Service difficulty reports · 242
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 = 'N7888A' 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 = 'N7888A' 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 SWAA2023112414498Floor Panel · pulledFLOOR PANEL 242DF UPPER SKIN HAS AREAS OF PULLED STRANDS.<[01] FLOOR PANEL 242DF UPPER SKIN WITH AREAS OF PULLED STRANDS WAS REPLACED WITH A NEWLY FABRICATE FLOOR PANEL PER SRM 53-00-50-2R-0.;[02] INSPECTED AND VERIFIED. JOB COMPLETE.SDR SWAA2023112414485Floor Panel · pulledFLOOR PANEL 232RF UPPER SKIN HAS AREAS OF PULLED STRANDS.<[01] FLOOR PANEL 232RF WITH UPPER SKIN HAS AREAS OF PULLED STRANDS WAS REPLACED WITH A NEWLY FABRICATED FLOOR PANEL USING BMS 4-23 TY 2 LOT#1541638-1; RESIN FOR INSERTS BMS 5-107 LOT#1538621-1; THERMOMESDR SWAA2023112414486Floor Panel · pulledFLOOR PANEL 232SF UPPER SKIN HAS AREAS OF PULLED STRANDS.<[01] FLOOR PANEL 232SF UPPER SKIN WITH AREAS OF PULLED STRANDS WAS REPLACED WITH A NEWLY FABRICATED FLOOR PANEL PER SRM 53-00-50-2R-0.;[02] FINAL INSPECTION. JOB COMPLETE.SDR SWAA2023112414478Floor Panel · pulledFLOOR PANEL 231AF UPPER SKIN HAS AREAS OF PULLED STRANDS.<[01] FWD FLOOR PANEL 231AF UPPER SKIN WITH AREAS OF PULLED STRANDS WAS REPLACED WITH A SERVICEABLE FLOOR PANEL PER SRM 51-10-02-0G-0 PARA 9.A.1 DUE TO AMOUNT OF ALL DAMAGE.;[02] PANEL REPLACED. JOB COMPSDR SWAA2023112414479Floor Panel · pulledFLOOR PANEL 231BF UPPER SKIN HAS AREAS OF PULLED STRANDS.<[01] FLOOR PANEL 231BF UPPER SKIN WITH AREAS OF PULLED STRANDS WAS REPLACED WITH A SERVICEABLE FLOOR PANEL PER SRM 51-10-02-0G-0 PARA 9.A.1.;[02] VERIFIED CORRECTIVE ACTION ITEM 1 AND MEASUREMENT TABLE.SDR SWAA2023112414480Floor Panel · pulledFLOOR PANEL 231CF UPPER SKIN HAS AREAS OF PULLED STRANDS.<[01] FLOOR PANEL 231CF UPPER SKIN WITH AREAS OF PULLED STRANDS WAS REPLACED WITH A SERVICEABLE FLOOR PANEL PER SRM 51-10-02-0G-0 PARA 9.A.1 DUE TO AMOUNT OF ALL DAMAGE.;[02] VERIFIED CORRECTIVE ACTION ISDR SWAA2023112414482Floor Panel · pulledFLOOR PANEL 241UF UPPER SKIN HAS AREAS OF PULLED STRANDS.<[01] DUE TO THE EXTENT OF ALL OF THE DAMAGE; DECIDED TO FABRICATE A NEW FLOOR PANEL USING BMS4-23 TYPE II LOT 1541638-1 AND BMS5-107 LOT 1540837-1 RESIN; CURED THE RESIN UNDER A HEAT LAMP USING THERMOMESDR SWAA2023112414483Floor Panel · pulledFLOOR PANEL 231XF UPPER SKIN HAS AREAS OF PULLED STRANDS.<[01] DUE TO THE EXTENT OF DAMAGE; FABRICATED NEW FLOOR PANEL 231XF IAW SRM 53-00-50-2R-0 AND BOEING DWG 144A5810 ID:0126.;[02] VERIFIED FABRICATION OF FLOOR PANEL 231XF PER SRM 53-00-50-2R-0 AND BOEING SDR SWAA2023112414484Floor Panel · pulledFLOOR PANEL 241YF UPPER SKIN HAS AREAS OF PULLED STRANDS. PANEL IS ACTUALLY 231YF.<[01] FLOOR PANEL 231YF UPPER SKIN WITH AREAS OF PULLED STRANDS WAS REPLACED WITH A NEWLY FABRICATE FLOOR PANEL PER SRM 53-00-50-2R-0.;[02] INSPECTED AND VERIFIED. JOB COMPLETE.SDR SWAA2023112414487Floor Panel · pulledFLOOR PANEL 241AF UPPER SKIN HAS AREAS OF PULLED STRANDS.<[01] FABRICATED FLOOR PANEL 241AF IAW SRM 53-00-50-2R-0;[02] VERIFIED FABRICATION OF FLOOR PANEL 241AF PER SRM 53-00-50-2R-0 AND DWG 144A5810-127.SDR SWAA2023112414488Floor Panel · pulledFLOOR PANEL 241DF UPPER SKIN HAS AREAS OF PULLED STRANDS.<[01] FLOOR PANEL 241DF UPPER SKIN WITH PULLED STRANDS WAS REPLACED WITH A NEW FABRICATED PANEL IAW SRM 53-00-50-2R-0 AND BAC DWG 144A5810 ID:0128.;[02] VERIFIED CORRECTIVE ACTION 1SDR SWAA2023112414491Floor Panel · pulledFLOOR PANEL 242PF UPPER SKIN HAS AREAS OF PULLED STRANDS.<[01] DUE TO EXTENT OF DAMAGE FABRICATED NEW 242PF FLOOR PANEL FROM BMS4-23TY2 LOT#1541638-1; INSERTS INSTALLED USING BMS5-107 LOT#1538621-1 THEN CURED USING HEAT LAMP AND THERMOMETER ATS2192 CAL DUE DATSDR SWAA2023112414492Floor Panel · pulledFLOOR PANEL 231ZF UPPER SKIN HAS AREAS OF PULLED STRANDS.<[01] FLOOR PANEL 231ZF UPPER SKIN WITH AREAS OF PULLED STRANDS WAS REPLACED WITH A NEWLY FABRICATE FLOOR PANEL PER SRM 53-00-50-2R-0.;[02] INSPECTED AND VERIFIED. JOB COMPLETE.SDR SWAA2023112414493Floor Panel · pulledFLOOR PANEL 241BF UPPER SKIN HAS AREAS OF PULLED STRANDS.<[01] FLOOR PANEL 241BF WAS REPLACED BY FABRICATION IAW SRM 53-00-50-2R-0 AND DRAWING 144A5810 SHEET 190.;[02] VERIFIED CORRECTIVE ACTION 1SDR SWAA2023112414481Floor Panel · pulledFLOOR PANEL 232BF UPPER SKIN HAS AREAS OF PULLED STRANDS.<[01] FLOOR PANEL 232BF UPPER SKIN WITH AREAS OF PULLED STRANDS WAS REPAIRED PER SRM 53-00-50-2R-1. ATTACHED CURE SHEETS TO THIS FAULT RECORD.;[02] VERIFIED CORRECTIVE ACTION 1SDR SWAA2023112714016Bulkhead · crackedR/H STA 663 VAPOR BARRIER COMPOSITE BULKHEAD IS CRACKED FROM WL 165 TO 149; RBL 46 TO 52.<[01] RIGHT HAND STATION 663 VAPOR BARRIER COMPOSITE BULKHEAD CRACK; FROM WATERLINE 165 TO 149; RBL 46 TO 52 WAS REPAIRED IAW SRM 51-70-04-2R-10.;[02] FINAL INSPECTION. JOSDR SWAA2023112714017Bulkhead · crackedL/H STA 663 VAPOR BARRIER COMPOSITE BULKHEAD IS CRACKED FROM WL 160 TO 150; LBL 46 TO 52.<[01] LEFT HAND STATION 663 VAPOR BARRIER COMPOSITE BULKHEAD CRACK; FROM WATERLINE 160 TO 150; LBL 46 TO 52; WAS REPAIRED IAW SRM 51-70-04-2R-10.;[02] FINAL INSPECTION. JOSDR SWAA2023112714470Elbow · crackedELBOW FITTING CRACKED COMMON TO THE 'B' SYSTEM RETURN LINE P/N 272A4451-116<[01] INSTALLED NEW ELBOW FITTING COMMON TO THE 'B' SYSTEM RETURN LINE P/N: 272A4451-116PER AMM 20-10-51-400-804. TORQUE WRENCH USED ID: ATS2321 DUE: 06/2024.;[02] LEAK CHECK REQUIRED.;SDR SWAA2023112714474Strap · corrodedCORROSION ON STRAP AT MID PASSENGER CABIN BS703 RBL63 WL202. MARKED<[01] 'REFER TO FAULT TTG8Q00P7PBV WHERE EA 23-153-03217 WAS ADDED AS A SUBTASK.';[02] VERIFIED CORRECTIVE ACTION #1;[03] REFER TO FAULT TTG8Q00P7PBV WHERE EA 23-153-03217 WAS ADDED AS A SUBTASSDR SWAA2023112714475Strap · corrodedCORROSION ON STRAP AT MID PASSENGER CABIN BS713 RBL67 WL202. MARKED<[01] 'REFER TO FAULT TTG8Q00P7PBV WHERE EA 23-153-03217 WAS ADDED AS A SUBTASK.';[02] VERIFIED CORRECTIVE ACTION #1;[03] REFER TO FAULT TTG8Q00P7PBV WHERE EA 23-153-03217 WAS ADDED AS A SUBTASSDR SWAA2023112714476Strap · corrodedCORROSION ON STRAP AT MID PASSENGER CABIN BS719 RBL67 WL202. MARKED<[01] 'REFER TO FAULT TTG8Q00P7PBV WHERE EA 23-153-03217 WAS ADDED AS A SUBTASK.';[02] VERIFIED CORRECTIVE ACTION #1;[03] REFER TO FAULT TTG8Q00P7PBV WHERE EA 23-153-03217 WAS ADDED AS A SUBTASSDR SWAA2023112714471Panel · crackedCRACKED PANEL BREAK AT MID CABIN BS540 RBL1 WL208.<[01] REMOVED; LOCATED; DRILLED AND INSTALLED NEW PANEL BREAK AT MID CABIN BS 540 BL 0 TO RBL 24 PER SRM 51-40-02; SRM 51-40-05 AND DWG143A0060;[02] CORRECTED MEASUREMENT TABLE;[03] VERIFIED CORRECTIVE ACTION 1SDR SWAA2023112716589Fitting · looseRT WING DEFLECTION CONTROL RIB UPPER PANEL ATTACH FITTING HAS LOOSE ATTACH BOLTS.<[01] REPAIRED RT WING DEFLECTION CONTROL RIB UPPER PANEL ATTACH FITTING IAW SRM 57-51-02-2R-4 REPAIR 4 AND CHECKED GOOD FLAP TO PANEL GAP IAW MM 57-50-01-820-801.SDR SWAA2023112414003Bulkhead · crackedCRACKED LOWER L/H COMPOSITE BULKHEAD AT BS663 LBL47 WL159.<[01] LH VAPOR BARRIER REPAIRED IN CUSTOMER FAULT TTG8Q00P70A5;[02] VERIFIED CORRECTIVE ACTION ENTRY 1. WITH MEASUREMENTS VERIFIED.SDR SWAA2023112414004Bulkhead · crackedCRACKED LOWER R/H COMPOSITE BULKHEAD AT BS663 RBL50 WL152.<[01] RH VAPOR BARRIER REPAIRED IN CUSTOMER FAULT TTG8Q00P707H;[02] VERIFIED CORRECTIVE ACTION ENTRY 1. WITH MEASUREMENTS VERIFIED.SDR SWAA2023112414007Attach Angle · crackedB.S. 663 LOWER COMPOSITE BULKHEAD UPPER ATTACH ANGLE IS CRACKED AT L.B.L. 45; W.L. 165.<[01] REPAIRED B.S. 663 LOWER COMPOSITE BULKHEAD UPPER ATTACH ANGLE IAW SRM 57-10-10-2R-5;[02] CUSTOMER CARD COMPLETESDR SWAA2023112214006Light · inoperativeEMERGENCY EGRESS LIGHTING FROM SEAT 11DEF AFT IS NOT ILLUMINATED.<[01] PERFORMED OPS CHECK ON EMERGENCY EXIT LIGHT AT SEAT 11DEF AFT IAW AMM 33-51-01-960-801 STEP 2.C.(2) TEST WAS GOOD; EMERGENCY EXIT LIGHT WAS ILLUMINATED.;[02] VERIFIED CORRECTIVE ACTION STEPSDR SWAA2023091400014Battery Pack · inoperativeOVERHEAD BIN EMERGENCY LIGHTS AT 14 AND 17 ABC ARE INOP.<[01] REMOVED AND REPLACED BATTERY PACK M1670 FOR EMERGENCY LIGHTS. IAW AMM 33-51-06. OPS CHECK GOOD.SDR SWAA2023081487359Battery Pack · inoperativeSEVERAL EMERGENCY LIGHTS ARE INOP<[01] R&R EMERGENCY LIGHT BATTERY PACKS LOCATED ABOVE FWD ENTRY LIGHT PER AMM 33-51-06SDR SWAA2023062060905Panel · crackedRT WING UPPER SURFACE PANEL #651ET HAS APPROX 14 INCH CRACK<[01] REMOVED AND REPLACED PANEL PER AMM 57-50-01;[02] C/W INSPECTIONSDR SWAA2023032118276Window · failedAIRCRAFT FAILED TO PRESSURIZE; FO SLIDING WINDOW LOCKED BUT DID NOT FULLY SEAL.<[01] FOUND FO?S SLIDING WINDOW NOT PROPERLY CLOSED; R & R?D FO?S SLIDING WINDOW PER MT 756-12-03. PERFORMED SATISFACTORY CABIN PRESSURE LEAK TEST PER AMM 05-51-91.SDR SWAA2023030812849Girt Bar · looseGIRT BAR SCREWS LOOSE ON FORWARD SERVICE DOOR.<[01] SECURED FASTENERS ON FWD SVC DOOR GIRT BAR PER SIP.SDR SWAA2023011089797Lamp · inoperativeCABIN EMERGENCY LIGHT ABOVE 17ABC IS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-03, OPS CHECKED GOOD.SDR SWAA2022102865495Light · inoperativeLH OVERWING EXIT DOOR WINDOW LIGHT INOP / [01] REMOVED AND REPLACED LH OVER WING EXIT DOOR WINDOW LIGHT ASSY IAW AMM 33-21-00.SDR SWAA2022021069701Flashlight · inoperativeAFT FA FLASHLIGHT HOLDER INOP ; / [01] R&R FLASHLIGHT HOLDER PER AMM 25-64-00SDR SWAA2022013163837Megaphone · inoperativeMEGAPHONE INOP AFT GALLEY ; / [01] REPLACED MEGAPHONE BATTERIES AS NEEDED AMM 25-64-00 OPS CHK GOOD.SDR SWAA2022010655783Seal · out of positionR/H STAB SLIDE SEAL NOT INSIDE TRACKS. REFERENCE PANEL 343AB. ; / [01] REMOVED AND RE-INSTALLED RT. STAB SLIDE SEAL PANEL 343AB IAW AMM 27-41-11-400-801 STEP 3G(15).SCREW GUN I.D. 7641C S/N G97640 CAL DATE 11/2022; [02] VERIFIED PROPER SLIDE SEAL INSTALLATION;SDR SWAA2022011054715Baffle · corrodedCORROSION R/H BAFFLE UPPER FLANGE LOWER SURFACE BS 747 - 767 RBL 22 WL 153 ; / [01] REMOVED CORROSION ON R/H BAFFLE FLANGE LOWER SURFACE B/S 747-767 RBL 22 WL 153 REWORKED AREA L=2.'; W=1.'D=0.005' ORIGINAL THICKNESS 0.032'. FOUND TO BE OUT OF LIMITS IAW SRM 5SDR SWAA2022010454709Battery Pack · inoperativeEMERGENCY EXIT LIGHTS ASSOCIATED WITH BATTERY PACK M1674 ARE INOP. REMOVED AND INSTALLED SERVICEABLE EMERGENCY EXIT LIGHTS POWER SUPPLY AT POSITION M1674 AND PERFORMED GOOD INSTALLATION TEST AS PER AMM. 33-51-06-960-806.SDR SWAA2022010554193Baffle · crackedSUPPLEMENTAL INFORMATION: CRACKED BAFFLE IN FCB BS 500B TO 500C RBL25 WL 156 ; / [01] DAMAGE FOUND ON BAFFLE IN FCB BS500B TO BS500C RBL25 WL156 FOUND TO BE OUT OF LIMIT DUE TO NO LIMIT ON SRM PARTS WILL BE REPAIRED BY REPLACEMENT IAW SRM 51-10-02-0G-0 PAR. 9.SDR SWAA2022010553106Track · crackedSUPPLEMENTAL INFORMATION: CRACKED TRACK AT AFT CARGO BAY BS727E LBL17 WL156. ; / [01] CRACK FOUND AT ACB FLOOR TRACK BS-727E LBL-17; WL-156 P/N 146A7501-1 FOUND TO BE OUT OF LIMIT DUE TO CRACK LENGTH MEASURED 0.2' EXCEED THE LIMIT IAW SRM 53-00-52-1A-2 DETAIL SDR SWAA2022010553096Angle · crackedSUPPLEMENTAL INFORMATION: CRACKED INTERCOSTAL ATTACH ANGLE AT FWD CARGO BAY BS420 RBL25 WL157. MARKED. ; / [01] DAMAGE FOUND ON INTERCOSTAL ATTACH ANGLE AT FWD CARGO BAY BS420 RBL25 WL157; FOUND TO BE OUT OF LIMITS DUE TO O LIMITS ON SRM PART WILL BE REPAIRED SDR SWAA2022011053105Support · corrodedCORROSION ON FLOOR TO SIDEWALL SUPPORT AT AFT CARGO BAY BS727 - BS767 RBL22. ; / [01] AFT RH FLOOR TO SIDEWALL SUPPORT WAS REMOVED ON CUSTOMER CARD:TTG8Q004CYGY<BR><BR>BLENDED CORROSION ON RH FLOOR TO SIDEWALL SUPPORT FROM BS 727 - BS 787. REMOVED .021' (IN DESDR SWAA2022011053108Attach Angle · corrodedCORROSION ON KEEL BEAM ATTACH ANGLE AT AFT CARGO BAY BS727B LBL7. MARKED. ; / [01] REMOVED CORROSION ON KEEL BEAM ATTACH ANGLE AT AFT CARGO BAY BS727B LBL7; AREA 1.1'X0.7'X0.018' IAW SRM 51-10-02-0G-0; FOUND TO BE OUT OF LIMITS DUE TO NO ALLOWABLE DAMAGE IN SRSDR SWAA2022011053310Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK RBL25 BS545; BS554; BS578 - BS590; BS605; BS616; BS638; BS649; BS667 - BS679; BS697 WL208.1 ; / [01] COMPLETED STEPS; [02] VERIFIED COMPLETION OF STEPS 1-9; [03] APPLIED A CHEMICAL CONVERSION COATING AND ONE LAYER OF EPOSDR SWAA2022011053303Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK RBL45 BS386; BS403; BS410; BS444 WL208.1 ; / [01] COMPLETED ALL STEPS; [02] VERIFIED COMPLETION OF STEPS 1-3; [03] APPLIED A CHEMICAL CONVERSION COATING AND ONE LAYER OF EPOXY PRIMER TO REWORKED AREAS IAW SRM 51-20-01 ANSDR SWAA2022011053101Support · corrodedCORROSION ON FLOOR TO SIDEWALL SUPPORT AT AFT CARGO BAY BS727 -BS807 LBL21. MARKED. ; / [01] REMOVED CORROSION FROM ACB FLOOR TO SIDE WALL SUPPORT ANGLE BS-727 TO BS-807; LBL-21 MAXIMUM MATERIAL REMOVED IN AREA OF 2'X 2'X 0.020' DEEP ORIGINAL MATERIAL THICKNESSDR SWAA2022011053093Shield · corrodedCORROSION ON FWD SHIELD AT AFT CARGO BAY BS771; BS775; BS779; BS783; RBL22. MARKED. ; / [01] THIS PART DOES NOT HAVE ENTRY ON THE LOWER ALLOWABLE DAMAGE LIMITS THERE FOR IT HAS TO BE REPAIRED BY REPLACEMENT PER SRM 51-10-02 STEP 9; [02] VERIFIED CORRECTIVE ACTSDR SWAA2022011053089Web · corrodedCORROSION ON SUBTHRESHOLD WEB AT FWD CARGO BAY RBL28 BS460; BS468; BS480; BS483. MARKED ; / [01] COMPLETED PARTIAL STEP 1-4.; [02] CORRECTION MEASUREMENTS AND STEP 1-4.; [03] COMPLETED STEPS 1-4; VERIFIED WEB IS OUT OF LIMITS; [04] REMOVED SUBTHRESHOLD WEB AT SDR SWAA2022011053102Cargo Track · corrodedCORROSION ON TRACK TIEDOWN AT AFT CARGO BAY BS727B; BS787; BS790 LBL17. MARKED. ; / [01] REMOVED CORROSION FROM ACB FLOOR TRACK MAXIMUM MATERIAL REMOVED FROM BS-787; LBL-17; WL-156 IN AREA OF 1'X1'X 0.025' DEEP IN TOP SURFACE OF TRACK FOUND TO BE OUT OF LIMIT
Back to N7888A