Boeing 737-76N
Service difficulty reports · 4,807
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = '73776N' 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 aircraft_model_key = '73776N' 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 SWAA2016032150079Plate · corrodedSIDE PLATE ASSEMBLY CORRODED, BETWEEN BS 727 - 847, LBL 22. R & R SIDE PLATE ASSEMBLY IAW SRM.SDR SWAA2016032150061Plate · corrodedSIDE PLATE ASSEMBLY CORRODED, BETWEEN BS 727 - 767, RBL 22. R & R SIDE PLATE ASSEMBLY IAW SRM.SDR SWAA2016032150060Support · corrodedFORWARD ENTRY DOOR SCUFF PLATE INBD SUPPORT CORRODED. R & R SUPPORT IAW SRM.SDR SWAA2016031749974Cargo Track · corrodedAFT CARGO FLOOR TRACK CORRODED AT STATION 727E - 847, RBL 13. R & R FLOOR TRACK IAW SRM.SDR SWAA2016031449875Fitting · crackedINTERCOSTAL TO FRAME CLIP CRACKED AT BS 500B, LBL 24. R & R CLIP IAW SRM.SDR SWAA2016031449874Fitting · crackedINTERCOSTAL TO FRAME CLIP CRACKED AT BS 500C, LBL 24. R & R CLIP IAW SRM.SDR SWAA2016031449873Support · corrodedFLOOR TO SIDE WALL SUPPORT CORRODED, BETWEEN BS 472 - 500+11, RBL 24. R & R SUPPORT IAW DWG & SRM.SDR SWAA2016032150017Rib · crackedRIGHT HORIZONTAL STABILIZER STATION 120.30 RIB, 3RD AFT VERTICAL STIFFENER CRACKED AT LOWER END. REPAIRED RIB IAW SRM.SDR SWAA2016032350172Skin · crackedRIGHT WING NR 6 LE SLAT, LOWER SKIN CRACKED AT ACT RIB CUT OUT. REPAIRED SKIN IAW SRM.SDR SWAA2016030449643Bulkhead · crackedWING CTR SECTION REAR SPAR BULKHEAD CRACKED AT BS 663, LBL 36. REPAIRED BULKHEAD IAW EA.SDR SWAA2016022949537Fitting · corrodedRIGHT MLG TRUNNION FITTING LUG FACES CORRODED. R & R FITTING IAW EA.SDR SWAA2016022949536Fitting · corrodedLEFT MLG TRUNNION FITTING LUG FACES CORRODED. R & R FITTING IAW EA.SDR SWAA2016022349301Slide · unsecureR1 DOOR EMER EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY. R & R SLIDE IAW MT.SDR SWAA2016022349300Sign · unsecureR1 DOOR EMER EXIT LOWER SIGN FELL OFF. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2016021048916Battery Pack · dischargedAFT CTR AISLE EMER EXIT LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2016020548747Slide · out of positionR1 DOOR EMER EVAC SLIDE GIRT OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2016020548746Roll Pin · missingR2 DOOR EMER EVAC SLIDE LOWER LATCH BLOCK ROLL PINS MISSING. REINSTALLED PINS IAW MT.SDR SWAA2016020348637Light · inoperativeL2 DOOR EMERGENCY EXIT SIGN LIGHT BULB INOP. R&R SIGN PER AMM.SDR SWAA2016012848451Battery Pack · failedRIGHT EMER EXIT MID CABIN EMER LIGHT BATTERY PACK FAILED CAPACITY TEST AT MO1669. R & R BATTERY PACK IAW AMM.SDR SWAA2016012848450Cap · missingL2 DOOR EMER EVAC SLIDE COVER, BUMPER BAR ENDCAP MISSING. INSTALLED ENDCAP IAW SRM.SDR SWAA2016020348636Plate · crackedFORWARD CARGO COMPARTMENT R/H INSIDE AND AFT OF FORWARD CARGO DOOR CUT-OUT INTERCOSTAL SIDE-PLATE CRACKED BETWEEN BS 492 TO BS 500A. R&R SIDE PLATE IAW DWG & SRM.SDR SWAA2016020448694Seat Track · corrodedLT OUTBOARD SEAT TRACK CORRODED BETWEEN BS 727B TO 947, LBL 45. R&R SEAT TRACK IAW SRM.SDR SWAA2016020248584Intercostal · corrodedINTERCOSTAL CORRODED AT BS 910, BETWEEN STRINGER 23L - 24L. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2016012148234Plate · crackedLEFT WING TE CAVITY, BETWEEN NR 5 & 6 SPOILERS, AFT SPAR LOWER CHORD WIGGLE PLATE CRACKED. R & R WIGGLE PLATE IAW DWG.SDR SWAA2016011948096Fitting · corrodedLEFT MLG FWD TRUNNION FITTING LUG FACES CORRODED. R & R FITTING IAW EA.SDR SWAA2016012048183Cover · looseR1 DOOR EMER EVAC SLIDE COVER DOOR CAME LOOSE. SECURED SLIDE COVER IAW AMM.SDR SWAA2016011948095Fitting · corrodedRIGHT MLG FWD TRUNNION FITTING LUG FACES CORRODED. R & R FITTING IAW EA.SDR SWAA2016061052754Cover · brokenL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR LIGHT COVER BROKEN. R & R COVER IAW MM.SDR SWAA2016020148567Frame · crackedFRAME CRACKED AT BS 827, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016012848448Scuff Plate · crackedAFT CARGO DOOR CUT OUT, FWD LOWER CORNER, SCUFF PLATE CRACKED. R & R SCUFF PLATE IAW SRM.SDR SWAA2016012748422Frame · crackedFRAME CRACKED AT BS 787, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016012748421Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016012748420Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2016012748419Frame · crackedFRAME CRACKED AT BS 867, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2016011548068Slide · low pressureR1 DOOR EMER EVAC SLIDE BOTTLE PRESS LOW. R & R SLIDE IAW MT & AMM.SDR SWAA2016020348650Plate · corrodedAFT CARGO COMPARTMENT, RT FLOOR SIDE PLATE CORRODED, BETWEEN BS 727 - 767. REMOVED PLATE IAW SRM.SDR SWAA2016020148566Plate · corrodedAFT CARGO COMPARTMENT LT FLOOR SIDE PLATE CORRODED, BETWEEN BS 727 TO 847. R & R SIDE PLATE IAW SRM.SDR SWAA2016012748418Threshold · corrodedAFT CARGO COMPARTMENT DOOR THRESHOLD WEB CORRODED, BETWEEN BS 787 - 847. R & R WEB IAW SRM.SDR SWAA2016020148565Plate · corrodedRIGHT SIDE PLATE TOP SURFACE, JUST AFT OF FWD CARGO DOOR CUT OUT CORRODED, AT BS 493. R & R SIDE PLATE IAW SRM.SDR SWAA2016010447624Plate · looseL1 DOOR GIRT BAR PLATING LOOSE. INSTALLED SCREWS AT PLATE ASSEMBLY IAW MM.SDR SWAA2016010447630Sign · looseAFT CABIN OVERHEAD EMER EXIT SIGN LOOSE. R & R SIGN IAW MM.SDR SWAA2015122947459Engine · failedAIR RETURN, INFLIGHT SHUTDOWN. NR 2 ENG LOUD BANG & SHUTDOWN. R & R NR 2 ENG IAW MT.SDR SWAA2015122847429Compressor · stalledCOMPRESSOR STALL AT NR 1 ENG. R & R NR 1 ENG IAW MM.SDR SWAA2015122347414Lens · looseRIGHT OVERWING EXIT SIGN LENS LOOSE. R & R LENS ASSEMBLY IAW MM.SDR SWAA2016010447607Housing · brokenAFT CTR CEILING EMER EXIT LIGHT HOUSING BROKEN. R & R LIGHT HOSING IAW MM.SDR SWAA2015121847276Battery · failedEMERGENCY LIGHT M01674 BATTERY FAILED TEST. R & R BATTERY IAW MM.SDR SWAA2015121847269Battery · failedEMERGENCY LIGHT M01675 BATTERY FAILED TEST. R & R BATTERY IAW MM.SDR SWAA2015123047524Retaining Clip · separatedL2 DOOR SLIDE GIRT BAR RETAINING CLIP SEPARATED. R & R CLIP IAW MM.SDR SWAA2016010447603Support · corrodedFLOOR TO SIDEWALL SUPPORT CORRODED AT STATION 492 - 500, RBL 24, WL 154. R & R SUPPORT IAW SRM.SDR SWAA2015121747268Rib · crackedRIGHT HORIZONTAL STABILIZER, STATION 92.70 RIB THIRD STIFFENER AFT LOWER END CRACKED. REPAIRED RIB IAW SRM.
Back to Boeing 737-76N