N7881A
Service difficulty reports · 185
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 = 'N7881A' 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 = 'N7881A' 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 SWAA2022032425915Panel · crackedLEFT WING LEADING EDGE PANEL 521HB FORWARD INBOARD CORNER IS CRACKED AT FASTENER HOLE / REPAIRED AND RESTORED PAINT FINISH TO PNL 521 HB FWD INBD CORNER FASTNER HOLE ELONGATED AND CRACKED MARKED. IAW B737-700 SRM 51-41-01-2R-1 REV 69; SRM 51-70-04-2R-9 REV 69;SDR SWAA2019101437768Battery Pack · no testEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATIONS M1668, M1669, M1672 AND M1675. R&R BATTERIES PER AMM.SDR SWAA2019101437767Slide · unpackedL2 DOOR SLIDE GIRT NEEDS REPACKED. REPACKED SLIDE PER MT AND AMM.SDR SWAA2019082736264Pump · low pressureLEFT CENTER FUEL PUMP LOW PRESSURE LIGHT ON W/2800 LBS. FUEL IN TANK. R&R LT CENTER BOOST PUMP PER AMM.SDR SWAA2019082236124Slide · out of adjustL2 DOOR SLIDE PARTIALLY OUT OF BOX, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW AMM & MT.SDR SWAA2018081324204Slide · unsecureR2 DOOR SLIDE CAME OUT OF HOUSING. R&R SLIDE PER MT.SDR SWAA2018060622557Slide · looseR1 DOOR EMERGENCY ESCAPE SLIDE SKIRT LOOSE FROM SHROUD. SECURED SLIDE PER MM.SDR SWAA2018041021020Hook And Loop · looseR2 DOOR SLIDE LOOSE. SECURED THE HOOK AND LOOP STRIP IAW AMM.SDR SWAA2018032220608Floor Support · crackedFLOOR SUPPORT CRACKED AT BS 540, BETWEEN RBL 20 TO RBL 40. R&R SUPPORT PER SRM.SDR SWAA2018032020563Pressure Panel · crackedVERTICAL PRESSURE WEB CRACKED AT BS 663, RBL 40. REPAIRED WEB PER SRM.SDR SWAA2018030120172Lens · brokenR1 DOOR EMERGENCY EXIT LIGHTED SIGN LENS BROKEN. R & R THE LENS IAW SIP.SDR SWAA2018021919777Trunnion · corrodedLEFT MAIN LANDING GEAR FORWARD TRUNNION LUG FACE FITTING CORRODED. REPAIRED THE FITTING IAW EA.SDR SWAA2017112818065Light · inoperativeL2 DOOR EMERGENCY EXTERIOR LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2022020425770None · crackedFLOOR SUPPORT BRAKE ASSY PANEL AT STA 540 LEFT OF BL 0 CRACKED / REMOVED AND REPLACED FLOOR SUPPORT BRAKE ASSY PANEL AT STA 540 LEFT OF BL 0 IAW SRM 51-40-02SDR SWAA2017111517844Barrier · crackedLT WHEEL WELL FORWARD WALL VAPOR BARRIER CRACKED AT BS 663. REPAIRED BARRIER IAW EA.SDR SWAA2017061914460Fitting · brokenL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR LOCKING CLIP BROKEN. R&R CLIP PER AMM.SDR SWAA2017041713132Slide · out of positionR1 DOOR SLIDE OUT OF POSITION. REPOSITIONED THE SLIDE IAW MT.SDR SWAA2016090655500Lens · dirtyAFT CARGO DOOR FORWARD EMERGENCY LIGHT LENS DIRTY. R & R THE LENS IAW AMM.SDR SWAA2016090655499Lens · dirtyL1 DOOR AFT EMERGENCY LIGHT LENS DIRTY. R & R THE LENS IAW AMM.SDR SWAA2016090655498Battery Pack · inoperativeLEFT MID-CABIN EMERGENCY BULLNOSE LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016090655495Battery Pack · inoperativeR1 DOOR AFT EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016090655494Battery Pack · inoperativeRIGHT OVERHEAD BINS BULLNOSE EMERGENCY LIGHT INOPERATIVE BETWEEN ROWS 3 TO 4. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016090655493Fuse · inoperativeLEFT OVERWING EMERGENCY EXIT LIGHT INOPERATVE. R & R THE FUSE IAW AMM.SDR SWAA2016082555136Support · corrodedRIGHT FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS. 847 - 867. R & R THE SUPPORT IAW SRM.SDR SWAA2016082555135Cargo Track · corrodedAFT CARGO BAY RT CARGO TRACK CORRODED AROUND FASTENER HOLES BETWEEN BS 787 - 827. R & R THE CARGO TRACK IAW SRM AND DWG.SDR SWAA2016082555134Support · corrodedAFT CARGO BAY LEFT FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 727 - 847. R & R THE SUPPORT IAW DWG & SRM.SDR SWAA2016082555133Support · corrodedAFT CARGO BAY RIGHT FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 727 - 767. R & R THE SUPPORT IAW DWG & SRM.SDR SWAA2016082455116Web · corrodedAFT CARGO DOOR SUB THRESHOLD WEB CORRODED. R & R THE WEB IAW SRM.SDR SWAA2016082455115Frame Splice · corrodedFRAME SPLICE CORRODED AT BS 787, BETWEEN STRINGERS 24 - 25R. R & R THE FRAME SPLICE IAW SRM.SDR SWAA2016082455114Stringer Clip · corrodedSTRINGER CLIP 26L CORRODED AT BS 727E. R & R THE STRINGER CLIP IAW SRM.SDR SWAA2016082555132Support · corrodedFORWARD CARGO BAY FLOOR-TO- SIDEWALL SUPPORT CORRODED BETWEEN BS 400 - 480, LBL 24. R & R THE SUPPORT IAW SRM.SDR SWAA2016082555131Support · corrodedFORWARD CARGO COMPARTMENT FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 500A - 500D, RBL 24. R & R THE SUPPORT IAW SRM.SDR SWAA2016082555130Plate · crackedLEFT WING REAR SPAR WIGGLE PLATE ASSEMBLY CRACKED AT RSS 216. R & R WIGGLE PLATE ASSEMBLY IAW SRM.SDR SWAA2016082555129Plate · crackedR/H WING REAR SPAR WIGGLE PLATE ASSEMBLY CRACKED AT RSS 216. R & R THE WIGGLE PLATE ASSEMBLY IAW SRM.SDR SWAA2016082955226Rib · crackedLEFT HORIZONTAL STABILIZER RIB AT CRACKED AT STA 92.70, 2ND STIFFENER FROM FORWARD END. REPAIRED RIB IAW SRM.
Back to N7881A