Boeing 737-4Q8
Service difficulty reports · 6,250
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 = '7374Q8' 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 = '7374Q8' 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 ASAA2013032512432Door Frame · corrodedR2 DOOR BS 958 SURROUND FRAME LOWER EDGE AT TOPSIDE OF FLOOR HAS A DEEP GOUGE AND CORRODED. REPAIRED IAW EA 400-53EA-10168.SDR ASAA2013032594696Frame · corrodedR2 GALLEY SERVICE DOOR STA 986, FRAME AT TOPSIDE OF FLOOR HAS OPEN HOLE ON BACKSIDE OF FRAME AND FRAME HAS CORRODED. ACFT GROUNDED. BLENDED CORRODED IAW SRM 51-10-02, MAT REMAINING IS OUT OF ALLOWABLE DAMAGE LIMITS IAW SRM 53-60-15. R & R DAMAGED LWR FRAMESDR ASAA2013032594573Frame · gougedFWD CARGO BS 400, FRAME GOUGED AT S25R. R & R SPLICE IAW SRM 51 40 02 0G 0, ITEM 4, PAGE 2.SDR ASAA2013032594538Stringer Clip · gougedFWD CARGO BS 480, STR 22L, STRINGER CLIP GOUGED R & R STRINGER CLIP IAW SRM 51 40 02 0G 0.SDR ASAA2013032494746Floor Support · corrodedAFT CARGO BS 772 CORRODED FLOOR SUPPORT LBL15. REPAIRED FLOOR SUPPORT IAW EA 400-53EA-10126.SDR ASAA2013032494679Support · corrodedAFT CARGO BAY FROM BS 727 TO STA 847 ABOVE 26L TRANSITION PANEL HAS SEVERAL AREAS OF CORROSION. ACFT GROUNDED. REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-60- 53. R & R TRANSITION PANEL IAW SRM 51-40-02, W 2.75, O .040, R .015, L 65, D .025.SDR ASAA2013032494638Door Frame · crackedFWD CARGO DOORWAY FWD FRAME CRACKED. ACFT GROUNDED. R & R FWD FWD DOOR FRAME IAW SRM 51-40-02-0G-0.SDR ASAA2013032494636Door Frame · crackedFWD CARGO DOORWAY AFT FRAME CRACKED. ACFT GROUNDED. R & R FWD CARGO DOORWAY AFT FRAME IAW SRM 51 40 02 0G 0.SDR ASAA2013032494600Seat Track · gougedSEAT TRACK AT RBL 24.75 FROM STA 727B TO STA 927 HAS NUMEROUS NICKS AND GOUGES. ACFT GROUNDED. R & R SEAT TRACK IAW SRM 53-00-52-2R-4 AND EA 400-53EA-04953, REV NEW.SDR ASAA2013032494596Seat Track · gougedSEAT TRACK AT LBL 45.5 FROM BS 727 TO 727B HAS NUMEROUS NICKS AND GOUGES. ACFT GROUNDED. R & R SEAT TRACK IAW SRM 51-40-02-0G-0 AND EA 400-53EA-04953, REV NEW.SDR ASAA2013032494589Floor Support · corrodedAFT CARGO PIT JUST AFT OF STA 772 AND BY 27L FLOOR SUPPORT IS CORRODED AROUND SCREW HOLE A250-034, LBL3. REPAIRED AFT CARGO FLOOR SUPPORT IAW ASA 400 53EA 10126.SDR ASAA2013032494588Transition Panel · corrodedAFT CARGO PIT BS 727 - 807 ABOVE 26R TRANSITION PANEL IS CORRODED. REMOVED, FABRICATED NEW AND INSTALLED AFT CARGO BAY RT TRANSITION PANEL FROM BS 727 - 727D IAW SRM 51-40-02, STEP B1.SDR ASAA2013032494568Frame · crackedFRAME AT BS 500B, RT SIDE HAS A CRACK AT THE 1 DIA WIRE PENETRATION HOLE APPROX .2500 LONG EXTENDING INBD FROM EDGE OF HOLE BELOW STRINGER 20R. REMOVED DAMAGE AND REPAIRED AREA ON FRAME BS 500B, STR 20 RT IAW SRM 53 00 07, REP 13.SDR ASAA2013032494564Skin · chafedRT OTBD MID FLAP INBD L/E CHAFED. REMOVED TWO DOUBLERS AND FILLERS IAW SRM 51-40-02. FABRICATED TWO REPAIR DOUBLERS AND ONE FILLER IAW SRM 57-53-01, FIG 201, CAD PLATED DOUBLER NR 2 IAW SRM 57-53-01, FIG 201, PRIMED TWO REPAIR PARTS AND ONE FILLER IAW AMM 51SDR ASAA2013032494556Skin · chafedRT OTBD AFT FLAP CHAFED AT NR 8 FAIRING. REPAIRED CHAFE ON RT OTBD AFT FLAP IAW SRM 51-70-10-2R-0, REPAIR 4, PARA 20, PG 48.SDR ASAA2013032494506Floor Support · corrodedAFT CARGO BAY, BS 727, CENTER FLOOR SUPPORT NUT PLATE RUSTED AND CORROSION ON SUPPORT. BLENDED CORROSION IAW SRM 51-10-02, FOUND TO BE OUT OF LIMITS IAW SRM 53-60-53. R & R CENTER FLOOR SUPPORT IAW SRM 51-40-02.SDR ASAA2013032494515Structure · chafedRT OTBD AFT FLAP CHAFED AT NR 8 FAIRING. REPAIRED CHAFE ON RT OTBD AFT FLAP IAW SRM 51-70-10-2R-0, REPAIR 4, PARA 20, PG 48.SDR ASAA2013032494479Seat Track · gougedSEAT TRACK AT RBL 24.75 FROM BS 540 TO 727 HAS NUMEROUS GOUGES. R & R SEAT TRACK IAW AMM 20-50-11-912-002, FIG 203.SDR ASAA2013032494477Seat Track · gougedSEAT TRACK AT LBL 45.5 FROM BS 540 TO 727 HAS NUMEROUS NICKS AND GOUGES. R & R SEAT TRACK IAW AMM 20-50-11-912-002, FIG 203.SDR ASAA2013032494476Seat Track · gougedSEAT TRACK AT RBL 45.5 FROM BS 540 TO 727 HAS NUMEROUS NICKS AND GOUGES. REMOVED AND REPLACED SEAT TRACK IAW AMM 20-50-11-912-002 FIG 203.SDR ASAA2013032494448Seat Track · gougedSEAT TRACK AT RBL 45.5 FROM STA 727B TO STA 927 HAS NUMEROUS NICKS AND GOUGED. R & R SEAT TRACK AT RBL 45 IAW SRM 51 40 02 0G 0.SDR ASAA2013032494447Seat Track · gougedSEAT TRACK AT LBL 45.5 FROM STA 480 TO STA 520 HAS NUMEROUS NICKS AND GOUGES. ACFT GROUNDED. REPAIRED SEAT TRACK AT LBL 45.5 IAW SRM 53 00 52, REP 2 AND ASA EA 400 53EA 04953, REV NEW DATED 09MAR11.SDR ASAA2013032494394Seat Track · gougedSEAT TRACK AT LBL 24.75 FROM BS 540 TO 727 HAS NUMEROUS NICKS AND GOUGES. R & R SEAT TRACK IAW SRM 51-40-02 AND EA 400 53EA 04953, REV NEW.SDR ASAA2013032494392Seat Track · gougedSEAT TRACK AT LBL 24.75 FROM BS 727 TO 727B HAS NUMEROUS NICKS AND GOUGES. R & R SEAT TRACK IAW 400 51 40 02 AND ASA EA 400 53EA 04953 REV NEW DATED 09MAR11.SDR ASAA2013032494389Seat Track · gougedSEAT TRACK AT RBL 45.5. FROM BS 727 TO 727B HAS NUMEROUS NICKS AND GOUGES. R & R TRACK IAW SRM 51 40 02 AND ASA EA 400 53EA 04953 REV NEW .SDR ASAA2013032394851Strap · crackedAVIONICS BAY CEILING SUPPORT STRAP CRACKED BS 328, RBL 32. ACFT GROUNDED. R & R CEILING STRAP IAW SRM 51-40-02.SDR ASAA2013032394817Strap · crackedAVIONICS BAY CEILING SUPPORT STRAP CRACKED BS 328, RBL 46. ACFT GROUNDED. R & R CEILING STRAP IAW SRM 51-40-02.SDR ASAA2013032394815Skin · chafedRT INBD AFT FLAP CHAFED. ACFT GROUNDED. REPAIRED RT INBD AFT FLAP IAW SRM 51-70-10.SDR ASAA2013032394599Sill · corrodedR2 DOOR MOPSILL IS CORRODED. ACFT GROUNDED. BLENDED R2 MOPSILL IAW SRM 51-10-02 MATERIAL REMAINING IS OUT OF ALLOWABLE DAMAGE LIMITS IAW SRM 53-60-15. R & R MOPSILL IAW SRM 51-40-02.SDR ASAA2013032394598Sill · corrodedL2 DOORWAY MOPSILL IS CORRODED. ACFT GROUNDED. REMOVED CORROSION IAW SRM 51-10-02, FOUND TO BE OUT OF LIMITS IAW SRM 53-60-15. LOCATED AND DRILLED IAW SRM 51-40-05 INSTALLED NEW L2 SILL IAW SRM 51-40-02.SDR ASAA2013032394540Skin · chafedRT INBD FOREFLAP CHAFED ON CENTER UPPER SIDE. REPAIRED IAW SRM 51-70-10-2R-4.SDR ASAA2013032394450Support Angle · chafedRT OTBD FOREFLAP ROLLER SUPPORT ANGLE CHAFED OTBD OF OTBD FLAP. R & R IAW SRM 51 40 02.SDR ASAA2013032394395Skin · dentedNR 1 SPOILER LOWER SURFACE HAS A DENT 4.3 FROM INBD EDGE & 7 FROM FWD EDGE A=0.15 Y=0.020 A/Y=7.5. OUT OF LIMITS IAW SRM 57 70 01, FIG 101, SHEET 7. REPAIRED DENT ON NR 1 SPOILER LOWER SURFACE IAW SRM 51-70-10-2R-0. REPAIR 4 PARA 20, PG 48.SDR ASAA2013032394362Skin · dentedLEFT OTBD FORE FLAP HAS A DENT 16 INCHES INBD OF CENTER SUPPORT AND 4 INCHES FROM T/E A=.10 AND Y=0.025 A/Y=.4 FOUND TO BE OUT OF LIMITS OF SRM 57-53-01, PG 109, FIG 101, DETAIL VIII. BONDED REPAIR IAW SRM 51 70 10, REPAIR 4.SDR ASAA2013032394301Stringer · corrodedAPU COMPARTMENT RAM AIR OPENING HAS CORROSION ON THE BOTTOM OF OPENING. BLENDED AREA FOUND TO BE OUT OF LIMITS IAW SRM 53-80-13 AD2. R & R STRINGER IAW SRM 51-40-02,SDR ASAA2013032194356Skin · chafedLT WING NR 2 SLAT INBD L/E INTER SURFACE IS CHAFED. REPAIRED IAW SRM 51-70-10, REPAIR 4, PARA 20, PG 48.SDR ASAA2013032194349Skin · chafedLT WING NR 3 SLAT INBD CORNER AND ABOVE ACTUATOR SURFACE IS CHAFED. REPAIRED LT WING NR 3 SLAT INBD CORNER AND ABOVE ACTUATOR SURFACE IAW SRM 51-70-10, REPAIR 4.SDR ASAA2013032094718Skin · chafedNR 5 SPOILER IS CHAFED ON LOWER SURFACE, ACFT GROUNDED. R & R AND REPLACED NR 5 SPOILER IAW AMM 27-62-12-004-001, STEP 2 D.1 THRU 10 AND EA 400-57EA-10219 AND DWG 66-46-452 AND SMM 27-62-12-404 012, STEP 3.E.3 THRU 5.SDR ASAA2013032094357Skin · chafedLEFT WING NR 2 SLAT OTBD INTER SURFACE OF T/E ON CORNER IS CHAFED. REPAIRED IAW SRM 51-70-10, REPAIR 4, PARA 20, PG 48.SDR ASAA2013031994582Floorboard · gougedFWD CARGO FLOORBOARD HAS SEVERAL DEEP GOUGES. FABRICATED NEW FLOORBOARD IAW SRM 51-40-05.SDR ASAA2013031994501Floorboard · gougedAFT CARGO NR 2 FLOORBOARD HAS DEEP GOUGES. FABRICATED, LOCATED AND DRILLED NEW FLOORBOARD IAW SRM 51-40-05.SDR ASAA2013031994491Floorboard · gougedAFT CARGO NR 4 FLOORBOARD HAS EXISTING LINE REPAIR AND SEVERAL DEEP GOUGES. FABRICATED, LOCATED AND DRILLER NEW FLOORBOARD IAW SRM 51-40-05 AND 51-20-01 AND SOPM 20-41-02.SDR ASAA2013031994444Floorboard · gougedAFT CARGO NR 3 FLOORBOARD HAS SEVERAL DEEP GOUGES. FABRICATED NEW FLOORBOARD IAW SRM 51 40 05.SDR ASAA2013031994443Floorboard · damagedFWD CARGO NR 1 FLOORBOARD DAMAGED. FABRICATED, LOCATED AND DRILLER NEW FLOORBOARD IAW SRM 51 40 05 06 P, FIG 9, TABLE 5.SDR ASAA2013031994393Access Panel · damagedLEFT T/E FLAP PANEL NR 8407 HAS ELONGATED FASTENER HOLE. FABRICATED NEW FLAP ACCESS PANEL IAW SRM 51 70 10, PARA 18, PG 43.SDR ASAA2013031994351Floorboard · corrodedAFT CARGO NR 2 FLOORBOARD SPLICE IS CORRODED. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS, FABRICATED NEW SPLICE IAW SRM 51-30-01, STEP 8AB.SDR ASAA2013031994350Floorbeam · corrodedAFT CARGO FLOORBEAM SPLICE TEE HAS CORROSION. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS FABRICATED NEW SPLICE IAW SRM 51 30 01, STEP 8 A-B.SDR ASAA2013031594276Skin · chafedLT WING OTBD MIDFLAP LOWER SURFACE SKIN IS CHAFED INBD OF NR 1 FLAP TRACK FAIRING. REPAIRED IAW EA CMPT-57EA-09933.SDR ASAA2013031594186Skin · chafedWEAR MARK ON THE LT OTBD MIDFLAP T/E AT THE CONTACT AREA WITH THE NR 1 FAIRING. REPAIRED THE LT OTBD MIDFLAP T/E AT THE CONTACT AREA WITH THE NR 1 FAIRING IAW EA CMPT-57EA-09933.SDR ASAA2013031594170Girt Bar · crackedL1 DOOR ESCAPE SLIDE GIRT BAR ARM CRACKED. REPAIRED IAW EA400-25EA-09973, REV NEW.
Back to Boeing 737-4Q8