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 SWAA2015081842934Light · inoperativeLEFT LOWER SIDEWALL EMER EXIT LIGHT INOPERATIVE AT ROW 11. RELAMPED IAW AMM.SDR SWAA2015081442847Light · inoperativeRIGHT OVERWING FWD EMER THRESHOLD LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2015081442846Slide · out of adjustR2 DOOR EMER EVAC SLIDE GIRT OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW MT.SDR SWAA2015081242753Retaining Clip · out of adjustR1 DOOR EMER EVAC SLIDE GIRT BAR RETENTION CLIP OUT OF ADJUSTMENT. ADJUSTED CLIP IAW SIP.SDR SWAA2015081142738Light · inoperativeLEFT OVERWING EXIT SIGNS LAMP ABOVE DOOR INOPERATIVE. R & R LAMP IAW AMM.SDR SWAA2015081142737Light · inoperativeRIGHT OVERWING EXIT SIGNS LAMP ABOVE DOOR INOPERATIVE. R & R LAMP IAW AMM.SDR SWAA2015080342477Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW MT.SDR SWAA2015080342453Lens · looseRIGHT OVERHEAD BIN EMERGENCY LIGHT LENS LOOSE AT ROW 6. SECURED LIGHT IAW SOPM.SDR SWAA2015080342444Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT L732. RELAMPED LIGHT IAW AMM.SDR SWAA2015080342437Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT L1063. RELAMPED LIGHT IAW AMM.SDR SWAA2015080342436Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT L731. RELAMPED LIGHT IAW AMM.SDR SWAA2015080342435Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT L6. RELAMPED LIGHT IAW AMM.SDR SWAA2015080342434Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT L733. RELAMPED LIGHT IAW AMM.SDR SWAA2015080342443Battery Pack · brokenM1675 EMERGENCY BATTERY CHARGER BROKEN AT BS 328, STRINGER 1L. R & R BATTERY PACK IAW AMM.SDR SWAA2015081342823Frame · crackedFRAME CRACKED AT BS 727D, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015080642582Frame · crackedFUSELAGE FRAME CRACKED AT BS 787, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015080642581Frame · crackedFUSELAGE FRAME CRACKED AT BS 727A, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015080642580Frame · crackedFUSELAGE FRAME CRACKED AT BS 500A, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015080642579Frame · crackedFUSELAGE FRAME CRACKED AT BS 480, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015080642578Frame · crackedFUSELAGE FRAME CRACKED AT BS 440, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015080642577Frame · crackedFUSELAGE FRAME CRACKED AT BS 400, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015080642576Frame · crackedFUSELAGE FRAME CRACKED AT BS 360, STINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015080642575Frame · crackedFRAME CRACKED AT BS 787, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015080642574Frame · crackedFRAME CRACKED AT BS 727D, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015080342428Frame · crackedFRAME CRACKED AT BS 867, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015080342427Frame · crackedFRAME CRACKED AT BS 747, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015080342426Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015080342425Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015080342424Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015080342423Frame · crackedFRAME CRACKED AT BS 360, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015082643245Hook · corrodedLEFT EMER EXIT HATCH ESCAPE STRAP HOOK CORRODED. R & R STRAP IAW AMM.SDR SWAA2015082643244Strap · corrodedRIGHT EMER EXIT HATCH ESCAPE STRAP HOOK. R & R STRAP IAW AMM.SDR SWAA2015082643243Beam · crackedR1 DOOR FWD FRAME LOWER STUB BEAM CRACKED AT INBD HOLE AT WL 208. REPAIRED STUB BEAM IAW ER & EA.SDR SWAA2015082643238Retaining Clip · brokenR2 DOOR EMER EVAC SLIDE GIRT BAR QUICK RELEASE RETAINER CLIP BROKEN. R & R CLIP IAW AMM.SDR SWAA2015082443079Slide · wornR2 DOOR EMER EVAC SLIDE SKIRT WORN. R & R SLIDE IAW CARD.SDR SWAA2015072742237Slide · looseL1 DOOR EVAC SLIDE LOOSE. SECURED SLIDE ASSEMBLY IAW MM.SDR CA150807005Wire Harness · shorted(CAN) THE CREW OBSERVED THE NR 2 FUEL TANK INDICATION FLUCTUATING, THE CREW SUSPECTED A POSSIBLE FUEL LEAK AND DIVERTED. MAINTENANCE REPLACED A FAULTED FUEL INDICATING COMPENSATOR AND THE ACFT WAS RETURNED TO SERVICE. THE DEFECT RE-OCCURRED 1 WEEK LATER AND SDR SWAA2015080642584Support · corrodedFORWARD CARGO COMPARTMENT FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 420 TO 440, BETWEEN STRINGER 24L TO 25L. R & R SUPPORT IAW SRM & DWG.SDR SWAA2015082643242Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 277 TO 294.5, UNDER FLOOR ACCESS PANEL 221AF. R & R INTERCOSTAL IAW SRM.SDR SWAA2015072242142Window · crackedL1 WINDOW DELAMINATED, ARCED & CRACKED. R & R NR 1 WINDOW IAW MM.SDR SWAA2015072042059Slide · out of positionR1 DOOR EMER EVAC SLIDE BATTERY FAST LOAD OUT OF POSITION. REPOSITIONED SLIDE ASSEMBLY IAW MT.SDR SWAA2015072042057Sign · missingL2 DOOR EXIT SIGN ASSEMBLY MISSING. R & R LIGHT ASSEMBLY AMM.SDR SWAA2015072342168Latch · brokenL1 DOOR EMER EVAC SLIDE SHROUD LATCH BROKEN. R & R LATCH IAW SRM.SDR SWAA2015071441929Module · faultyDIVERSION, OVERHEAT DETECTION FAULT LIGHT ILLUMINATED INTERMITTENTLY WITH OVERHEAT DETECTION SWITCH IN B POSITION. LOOP DEFERRED AS INOPERATIVE. R & R ENG FIRE DETECTOR MODULE IAW MM.SDR SWAA2015070941651Light · inoperativeAFT EXIT SIGN BULB INOPERATIVE. RELAMPED BULB IAW AMM.SDR SWAA2015071641996Fitting · corrodedRIGHT MLG LOWER TRUNNION FITTING FACES CORRODED. R & R FITTING IAW EA.SDR SWAA2015080342442Frame · crackedAFT CARGO FRAME CRACKED AT BS 727A, LBL 19. REPAIRED FRAME IAW EA.SDR SWAA2015062641190Intercostal · crackedINTERCOSTAL CRACKED AT STATION 927 TO 947, RBL 20. R & R INTERCOSTAL IAW SRM.SDR SWAA2015061740824Battery Pack · failedM01673 EMER BATTERY PACK FAILED CAPACITY TEST. R & R BATTERY PACK IAW MM.SDR SWAA2015061840892Slat · crackedRIGHT WING NR 5 SLAT CRACKED. REPAIRED NR 5 SLAT IAW SRM.
Back to Boeing 737-76N