Boeing 737-3H4
Service difficulty reports · 52,340
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 = '7373H4' 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 = '7373H4' 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 SWAA2014020624901Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STRINGER 20L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014020624900Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 336, BETWEEN STRINGER 20L TO STRINGER 21L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014020624897Angle · crackedRT WING NR 6 FLAP TRACK INTERNAL ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014020524893Tie Clip · crackedTIE CLIP CRACKED AT BS 727B, STRINGER 22L. R & R TIE CLIP IAW SRM.SDR SWAA2014020524892Tie Clip · crackedTIE CLIP CRACKED AT BS 727B, STRINGER 21L. R & R TIE CLIP IAW SRM.SDR SWAA2014020524891Tie Clip · crackedTIE CLIP CRACKED AT BS 727D, STRINGER 20L. R & R TIE CLIP IAW SRM.SDR SWAA2014020524890Tie Clip · crackedTIE CLIP CRACKED AT BS 727E, STRINGER 20L. R & R TIE CLIP IAW SRM.SDR SWAA2014020524889Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 320, BETWEEN STRINGER 20L TO STRINGER 21L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014020524888Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 328, BETWEEN STRINGER 20L TO STRINGER 21L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014020524876Support Fitting · crackedRT WING NR 5 GND SPOILER INBD ACTUATOR FWD WING SUPPORT FITTING CRACKED AT WBL 119.25. R & R FITTING IAW SRM & DRAWING.SDR SWAA2014020424838Web · crackedAFT CARGO COMPARTMENT FWD SIDE OF DOOR CUTOUT CLOSE OUT WEB CRACKED. REPAIRED WEB IAW SRM.SDR SWAA2014020324776Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2014020324764Skin · delaminatedRT WING NR 5 LE SLAT UPPER SURFACE DELAMINATED. R & R NR 5 SLAT IAW MM.SDR SWAA2014022425465Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A RT. R & R CHORD IAW EA.SDR SWAA2014022425464Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A LT. REPAIRED CHORD IAW SWA EA.SDR SWAA2014022425463Frame · crackedRT BS 727 FRAME OTBD CHORD CRACKED AT FWD FLANGE STRINGER 18A. REPAIRED CHORD IAW SWA EA.SDR SWAA2014022425462Frame · crackedLT FRAME CHORD CRACKED AT BS 727, STRINGER 18A. REPAIRED CHORD IAW EA.SDR SWAA2014022425452Bulkhead · crackedDOME CAP WEB CRACKED AT BS 1016, STRINGER 7L. REPAIRED WEB IAW SRM.SDR SWAA2014021925320Bulkhead · crackedDOME CAP WEB CRACKED AT BS 1016, STRINGER 15R. REPAIRED WEB IAW SRM.SDR SWAA2014021825275Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360, STRINGER 15L. R & R CHANNEL IAW SRM & DRAWING.SDR SWAA2014021825274Rib · crackedLT WING RIB LOWER CHORD CRACKED AT WBL 135.5, BETWEEN STATION 2 TO STATION 3. REPAIRED CHORD IAW EA.SDR SWAA2014021725237Frame · crackedFRAME WEB CRACKED AT BS 328, BETWEEN STRINGER 20R TO STRINGER 21R. R & R FRAME IAW SRM & DRAWING.SDR SWAA2014021725236Fitting · crackedCLIP CRACKED AT BS 380, BETWEEN STRINGER 25R TO STRINGER 26R. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014021725235Fitting · crackedCLIP CRACKED AT BS 380, BETWEEN STRINGER 25L TO STRINGER 26L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014021425142Stiffener · crackedZ STIFFENER CRACKED AT BS 1016, STRINGER 5R. R & R Z STIFFENER IAW SRM & DRAWING.SDR SWAA2014021425141Frame · crackedFRAME CRACKED AT BS 947.5, STRINGER 19R. R & R FRAME IAW SRM & DRAWING.SDR SWAA2014021325126Floor Support · crackedLONGITUDINAL FLOOR BEAM FLANGE CRACKED AT BS 727B, RBL 24.8. REPAIRED FLANGE IAW EA.SDR SWAA2014021125067Pressure Deck · crackedPRESS DECK CRACKED AT BS 664, RBL 39. REPAIRED DECK IAW SRM.SDR SWAA2014020424830Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727A, STRINGER 5R. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014020324766Skin · crackedLT NOSE WW SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014022425451Shear Tie · corrodedSHEAR TIE CORRODED AT BS 867, BETWEEN STRINGER 27L TO STRINGER 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2014022425450Frame · corrodedFRAME CORRODED AT BS 807, BETWEEN STRINGER 27L & STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2014022425449Frame · corrodedFRAME SHEAR TIE CORRODED AT BS 787, BETWEEN STRINGER 26R TO STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2014022425448Frame · corrodedFRAME CORRODED AT BS 747, BETWEEN STRINGER 26R TO STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2014022125376Angle · crackedL1 DOOR RETAINER ANGLE CRACKED AT BS 348, BETWEEN STRINGER 8L TO STRINGER 9L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014022125375Splice · crackedAFT CARGO COMPARTMENT T SPLICE CRACKED AT BS 727D+6.5, BETWEEN STRINGER 25R TO STRINGER 25L. R & R T SPLICE IAW SRM & DRAWING.SDR SWAA2014021925319Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STRINGER 28L TO STRINGER 28R. REPAIRED FRAME IAW SRM.SDR SWAA2014021825273Support Fitting · crackedSUPPORT CLIP CRACKED AT BS 947.5, STRINGER 25R. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014021825272Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360, STRINGER 15L. R & R CHANNEL IAW SRM & DRAWING.SDR SWAA2014021825271Web · crackedWEB CRACKED AT BS 328, RBL 31.6. R & R WEB IAW SRM & DRAWING.SDR SWAA2014021825270Shear Tie · corrodedFRAME SHEAR TIE CORRODED AT BS 500D, BETWEEN STRINGER 27L TO STRINGER 28L. R & R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2014021725234Angle · corrodedANGLE CORRODED AT BS 807, BETWEEN STRINGER 25R TO STRINGER 26R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021725233Channel · corrodedCHANNEL CORRODED AT BS 767+5, LBL 12.50. REPAIRED CHANNEL IAW EA.SDR SWAA2014021725232Channel · corrodedCHANNEL CORRODED AT BS 767+5, LBL 8.10. REPAIRED CHANNEL IAW EA.SDR SWAA2014021725231Channel · corrodedCHANNEL CORRODED AT BS 767+5, LBL 3. REPAIRED CHANNEL IAW EA.SDR SWAA2014021725230Channel · corrodedCHANNEL CORRODED AT BS 767+5, RBL 3. REPAIRED CHANNEL IAW EA.SDR SWAA2014021425140Frame · corrodedFRAME CORRODED AT BS 947.5, & BETWEEN STRINGER 22R TO STRINGER 23R. R & R FRAME IAW SRM & DRAWING.SDR SWAA2014021425139Bracket · crackedL1 DOOR CUTOUT BRACKET CRACKED AT BS 303.8+5, STRINGER 15L. R & R BRACKET IAW SRM & DRAWING.SDR SWAA2014021325123Angle · crackedUNDER FLOOR STRUCTURE VERTICAL ANGLE CRACKED AT BS 328, RBL 31.6. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021125061Angle · crackedANGLE CRACKED BETWEEN BS 294.5 TO BS 303.9, STRINGER 16L. R & R ANGLE IAW SRM & DRAWING.
Back to Boeing 737-3H4