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 ASAA11410209Trans Panel · corrodedFWD CARGO LT TRANSITION PANEL FROM STA 500F 500G CORRODED. REPAIRED LT CARGO TRANSITION PANEL FROM STA 500B TO 500G IAW B737 400 SRM 53 30 53 FIG 201.SDR ASAA11410210Cusp Web · corrodedPASSENGER CABIN RT CUSP WEB CORRODED ON OUTBD EDGE AROUND FASTENERS BETWEEN STA 757G AND 747 STR 17R. FABRICATED AND INSTALLED REPLACEMENT CUSP WEB IAW SRM 53 60 13 AND SRM 51 40 02 (BOEING 737 400).SDR ASAA11410207Seat Track · gougedLEFT I/B SEAT TRACK GOUGED SEVERAL AREA STA 520 540. REMOVED FABRICATED NEW SEAT TRACK, INSTALLED IAW B737 400 MM 20 50 11 912 002 AND B737 400 SRM 51 40 05 AND ASA EA 400 53EA 0493.SDR ASAA11410206Floorbeam · corrodedCORROSION ON CABIN FLOORBEAM STA 947 LBL 24 RBL 24. C/W REPAIR OF 947 UPPER CAP IAW EA 400 53EA 05889 REV NEW DATE ISSUED 18 JUL 2011.SDR ASAA11410205Cusp Web · corrodedPASSENGER CABIN RT CUSP WEB CORRODED ON OUTBD EDGE AROUND FASTENERS BETWEEN STA 847 AND 867 STR 17R. FABRICATED NEW WEB IAW BOEING DRWG 65 47976. INSTALLED WEB IAW B737 400 SRM 51 40 02.SDR ASAA11410204Cusp Web · corrodedPASSENGER CABIN RT CUSP WEB CORRODED ON OUTBD EDGE AROUND FASTENERS BETWEEN STATION 747 AND 767 STR 17R. FABRICATED NEW WEB IAW B737 400 DRAWING 65C26402 15 AND INSTALLED WEB IAW B737 400 SRM 51 40 02.SDR ASAA1140208Stringer Clip · corrodedCORRODED STRINGER TIE BS 767 STR 26R. REMOVED AND REPLACED WITH NEW STRINGER TIE.SDR ASAA11410211Shear Tie · corrodedFWD CARGO SHEAR TIE CORRODED AT STA 460 BETWEEN STR 28R AND 27R. REPAIRED SHEAR TIE IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA11410169Bracket · corrodedL1 DOOR FWD GIRT BAR MOUNT AT FS 344 LBL 55 WAS FOUND CORRODED. REMOVED AND REPLACED FWD GIRT BAR MOUNT PER B737 400 AMM 20 50 11 912 002 FIG 203.SDR ASAA11410168Bracket · corrodedL1 DOOR FWD GIRT BAR MOUNT AT FS 312 LBL 54 WAS FOUND CORRODED. REMOVED AND REPLACED FWD GIRT BAR MOUNT PER B737 400 AMM 20 50 11 912 002 FIG 203.SDR ASAA11410141Sill · corrodedL1 DOOR MOP SILL IS CORRODED. REMOVED AND REPLACED OUT OF LIMITS L1 INNER CHORD IAW B737 400 SRM 53 10 15 FIG 101 51 40 05 AND 51 40 02.SDR ASAA11410139Shear Web · corrodedPAX CABIN RT SHEAR WEB CORRODED ON OUTBD EDGE AROUND FASTENERS BETWEEN STA 807 AND 827 STR 17R. FABRICATED NEW WEB IAW B737 400 SRM 51 30 01 AND INSTALLED IAW B737 400 SRM 51 40 02.SDR ASAA11410074Cusp Web · corrodedPAX CABIN LT CUSP WEB CORRODED ON OUTBOARD EDGE AROUND FASTENERS BETWEEN STA 867 AND 887 STR 17L. REPLACED WITH NEW FABRICATED WEB IAW B737 400 SRM 53 60 13.SDR ASAA11410068Cusp Web · corrodedPAX CABIN RT CUSP WEB CORRODED ON O/B EDGE AROUND FASTENERS BETWEEN STA 867 AND 887 STR 17R. REMOVED FABRICATED AND INSTALLED NEW CUSP WEB IAW B737 400 SRM 53 60 13 51 40 02 AND DWG 65C26402.SDR ASAA11410070Cusp Web · corrodedPAX CABIN RT CUSP WEB CORRODED ON O/B EDGE AROUND FASTENERS BETWEEN STA 727D AND 727E STR 17R. REPLACED WITH NEW FABRICATED WEB IAW B737 400 SRM 53 60 13 AND 51 40 02.SDR ASAA11410090Cargo Track · corrodedRBL 13.8 CARGO TIEDOWN TRACK CORRODED. FABRICATED REPAIR PARTS AND REPLACED CARGO TRACK IAW B737 400 SRM 53 00 53 REPAIR 2 (CARGO TRACK REPAIR LOWER LOBE).SDR ASAA11410087Seat Track · gougedLT INBOARD SEAT TRACK GOUGED IN SEVERAL AREAS FROM STA 344 TO 480. REPLACED SEAT TRACK PER B737 400 SRM 51 40 02.SDR ASAA11410085Support · corrodedTRANSITION PANEL LBL 21.8 NUT PLATE ZEE SUPPORT FROM FRAME 727C 727G WAS FOUND CORRODED. REPLACED TRANSITION PANEL ZEE PER B737 400 SRM 53 60 53 FIG 201.SDR ASAA11410084Support · corrodedAFT CARGO COMPARTMENT RBL 71.8 NUT PLATE SUPPORT CORRODED AT 727B TO 727E. REMOVED PANEL, FABRICATED A NEW ONE AND INSTALLED IAW B737 400 SRM 51 40 02.SDR ASAA11410089Cusp Web · corrodedPAX CABIN RT CUSP WEB CORRODED AT STA 787 STR 17R. REPLACED WITH NEW FABRICATED WEB AND INSTALLED IAW B737 400 SRM 51 40 01 AND SRM 51 40 02.SDR ASAA11410083Cusp Web · corrodedPAX CABIN RT CUSP WEB CORRODED BETWEEN STA 877 TO 847 STR 174. REPLACED WITH NEW FABRICATED WEB PER B737 400 SRM 51 30 01 AND 51 40 02.SDR ASAA11410077Cusp Web · corrodedPAX CABIN LT CUSP WEB CORRODED ON FWD AND AFT ENDS AROUND FASTENERS BETWEEN STA 807 AND 827 STR 17L. REPLACED WITH NEW FABRICATED WEB IAW B737 400 SRM 51 30 01 NR 8.SDR ASAA11410073Cusp Web · corrodedPAX CABIN LT CUSP WEB CORRODED ON AFT END BETWEEN STA 727B AND 727C STR 17L. REPLACED WITH NEW FABRICATED WEB IAW B737 400 SRM 51 30 01.SDR ASAA11410071Cusp Web · corrodedPAX CABIN CUSP WEB CORRODED ON O/B EDGE AROUND FASTENERS BETWEEN STA 767 AND 787 STR 17R. REPLACED WITH NEW FABRICATED WEB IAW B737 400 SRM 53 60 13 51 40 02 AND BAC DWG 65C26402.SDR ASAA11410069Cusp Web · corrodedPAX CABIN RT CUSP WEB CORRODED ON O/B EDGE FWD CORNER AROUND FASTENERS BETWEEN STA 727E AND 727F STRINGER 17R. REMOVED FABRICATED AND INSTALLED NEW CUSP WEB IAW B737 400 SRM 53 60 13 51 40 02.SDR ASAA11410057Frame · crackedOVERHEAD BIN ATTACH POINT CRACKED AT STA 727D BETWEEN STRINGER 8L AND 9L. REPAIRED FRAME AT STA 827 STR 8L & 9L IAW ASA EA AD20062609 400 53 121.SDR ASAA11410058Frame · crackedOVERHEAD BIN ATTACH POINT CRACKED AT STA 907 BETWEEN STRINGER 8R AND 9R. REPAIRED FRAME AT STA 907 STR 8R & 9R IAW ASA EA AD20062609 400 53 121.SDR ASAA11410056Frame · crackedOVERHEAD BIN ATTACH POINT CRACKED AT STA 827 BETWEEN STRINGER 8L AND 9L. REPAIRED FRAME AT STA 827 STR 8L & 9L IAW ASA EA AD20062609 400 53 121.SDR ASAA11410055Frame · crackedOVERHEAD BIN ATTACH POINT CRACKED AT STA 867 BETWEEN STRINGER 8R AND 9R. REPAIRED FRAME AT STA 867 STR 8R & 9R IAW ASA EA AD20062609 400 53 121.SDR ASAA11410054Frame · crackedOVERHEAD BIN ATTACH POINT CRACKED AT STA 867 BETWEEN STRINGER 8L AND 9L. REPAIRED FRAME AT STA 867 STR 8L & 9L IAW ASA EA AD20062609 400 53 121.SDR ASAA11410049Doubler · corrodedANTENNA DOUBLER CORRODED AT FRAME 727D 2727E BOTTOM CENTER (AFT CARGO). REPLACED WITH FABRICATED NEW DOUBLER IAW B737 400 SRM 51 40 02 AND 51 40 05 AND BAC DWG 65 65710.SDR ASAA11410022Frame · corrodedFRAME 727B CORRODED INBOARD OF STR 27R. REPAIRED THE 727B FRAME IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA11410011Trans Panel · corrodedFWD CARGO COMPARTMENT LT TRANSITION PANEL CORRODED STA 500D. REPAIRED LT FWD CARGO TRANSITION PANEL FROM STA 500B TO 500G IAW B737 400 SRM 53 30 53 FIG 201.SDR ASAA11410007Shear Tie · corrodedSHEAR TIE CORRODED AT FS 500B STR 27 28L. FABRICATED, DRILLED, TREATED AND INSTALLED SHEAR TIE REPAIR IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA11410005Shear Tie · corrodedFWD CARGO SHEAR TIE CORRODED AT FS 500D STR 28R 28L. FABRICATED DRILLED TREATED AND INSTALLED SHEAR TIE REPAIR IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA11410004Shear Tie · corrodedSHEAR TIE CORRODED AT FS 500D STR 27 28L. FABRICATED, DRILLED, TREATED AND INSTALLED SHEAR TIE REPAIR IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA11410001Floor Support · corrodedFWD CARGO SUPPORT ANGLE CORRODED AT FS 500F TO FS 500G AND STR 28R. FABRICATED, DRILLED, TREATED AND INSTALLED NEW SECTION OF FLOOR SUPPORT ANGLE IAW B737 400 SRM 51 40 05 AND SRM 53 00 03.SDR ASAA1149996Frame · corrodedFRAME STA 727G CORRODED AT STR 26L AFT CARGO COMPARTMENT. REPAIRED SHEAR TIE AT STA 727G IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA1149987Shear Tie · corrodedFWD CARGO SHEAR TIE CORRODED STA 500C BETWEEN STR 28L 28R. REPAIRED SHEAR TIE IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA1149983Seat Track · gougedRT INBOARD TRACK GOUGED AT SEVERAL AREA STA 480 520. REPAIRED SEAT TRACK IAW B737 400 SRM 53 00 52 FIG 201 AND AS EA 400 53EA 04953.SDR ASAA1149982Seat Track · gougedRT O/B SEAT TRACK GOUGED AT SEVERAL AREA STA 727B 927. REPAIRED SEAT TRACK IAW B737 400 SRM 53 00 52 FIG 201 AND AS EA 400 53EA 04953.SDR ASAA1149981Support · crackedAFT PIT FWD LT SIDEWALL LINER SUPPORT BROKEN. REPLACED WITH FABRICATED NEW SUPPORT PER DWG 65 55726 AND B737 400 SRM 51 40 05.SDR ASAA1149980Support · crackedSIDEWALL LINER SUPPORT CRACKED AT FRAME 727D AND STR 18R 19R. REPLACED WITH FABRICATED NEW SUPPORT PER DWG 69 73199 AND B737 400 SRM 51 40 02 AND SRM 51 40 05.SDR ASAA1149945Brace · crackedANTENNA DOUBLER CROSS BRACE CRACKED IN 3 PLACES AFT OF FRAME 727D. REMOVED CRACKED BRACE FABRICATED AND INSTALLED NEW CROSS BRACE PER B737 400 SRM 51 20 01, 51 40 05 AND SRM 51 40 02 PARA.7.SDR ASAA1149944Angle · crackedANTENNA SUPPORT ANGLES CRACKED AT FRAME 737D. REMOVED CRACKED ANGLES FABRICATED AND INSTALLED NEW ANGLES PER B737 400 SRM 51 20 01, 51 40 05 AND SRM 51 40 02 PARA 7.SDR ASAA1149943Angle · corrodedMAIN CABIN HAS CORROSION ON ANGLE AT STATION 991 LBL 32. REMOVED CORRODED ANGLE AND INSTALLED A FABRICATED NEW ANGLE PER B737 400 SRM 51 40 05.SDR ASAA1149942Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED AT FASTENER HOLE AT FS 967 LBL 28. REMOVED CORROSION AND REPAIRED FLOORBEAM AT FS 967 LBL 28 IAW B737 400 SRM 53 00 51.SDR ASAA1149937Angle · corrodedMAIN CABIN ZEE ANGLE WAS FOUND CORRODED AND OUT OF LIMITS. FABRICATED AND INSTALLED NEW ANGLE IAW B737 400 SRM 53 60 51.SDR ASAA1149900Door · out of adjustL1 DOOR VERY HARD TO OPEN & CLOSE. ADJUSTED L1 DOOR PER B737 400 AMM 52 11 00 705 007 STEPS E G(19). DOOR OPENING/CLOSING FORCES WITHIN LIMITS.SDR ASAA11410072Cusp Web · corrodedPAX CABIN RT CUSP WEB HAS CORROSION ON UPPER SURFACE BETWEEN STA 440 AND 460. REPLACED WITH NEW FABRICATED WEB IAW B737 400 SRM 53 30 13.
Back to Boeing 737-4Q8