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 SWAA2014081530890Skin · crackedSKIN CRACKED AT BS 827 STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2014081530889Skin · crackedSKIN CRACKED AT BS 807 STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2014081530888Skin · crackedSKIN CRACKED AT BS 807 STRINGER 2L. REPAIRED SKIN IAW EA.SDR SWAA2014081530887Skin · crackedSKIN CRACKED AT BS 801 STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2014081530886Skin · crackedSKIN CRACKED AT BS 787 STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2014081530885Skin · crackedSKIN CRACKED AT BS 727B STRINGER 2L. REPAIRED SKIN IAW EA.SDR SWAA2014091131842Fairing · crackedRIGHT WING NR 8 AFT FAIRING CRACKED ON EDGE. REPAIRED FAIRING IAW EA & SRM.SDR SWAA2014090931739Frame · corrodedFORWARD CARGO COMPARTMENT AFT & FWD SIDE OF FRAME CORRODED AT BS 500A BETWEEN STRINGER 28L TO 28R. REPAIRED FRAME IAW SRM.SDR SWAA2014090931738Frame · corrodedFORWARD CARGO COMPARTMENT AFT FACE OF FRAME CORRODED AT BS 400 BETWEEN STRINGER 23R TO 24R. REPAIRED FRAME IAW SRM.SDR SWAA2014090931737Crossbeam · crackedAFT CARGO COMPARTMENT DOOR FWD END OF THE CROSSBEAM E T CHORD CRACKED. REPAIRED ET CHORD IAW EA.SDR SWAA2014090831646Bracket · crackedFORWARD CARGO COMPARTMENT BRACKET CRACKED AT BS 500D STRINGER 19R. R & R BRACKET IAW SRM & DWG.SDR SWAA2014090831636Angle · crackedANGLE CRACKED BETWEEN BS 927 TO 947, BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2014090431594Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2 STRINGER 17L. R & R CHORD IAW EA.SDR SWAA2014090431593Channel · corrodedAFT CARGO CHANNEL CORRODED AT BS 727D+10 BETWEEN STRINGER 27L TO 27R. R & R CHANNEL IAW EA.SDR SWAA2014090231550Keelbeam · crackedKEEL BEAM WEB CRACKED AT BS 710. R & R WEB IAW SRM & DWG.SDR SWAA2014090231526Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D BETWEEN STRINGER 28L TO 28R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014090231520Bracket · crackedFORWARD CARGO COMPARTMENT BRACKET CRACKED AT BS 500D STRINGER 19L. R & R BRACKET IAW SRM & DWG.SDR SWAA2014082831389Plate · crackedVERTICAL STABILIZER DOOR RUDDER FRONT SPAR ACCESS PANEL 9503 PLATE CRACKED. R & R PLATE IAW SRM & DWG.SDR SWAA2014082531165Fitting · crackedFORWARD ENTRY DOOR SURROUND STRUCTURE FITTING CRACKED AT BS 303.9, STRINGER 13L. R & R FITTING IAW SRM & DWG.SDR SWAA2014081530915Window · arcedR1 WINDOW OUTER PANE ARCED. R & R R1 WINDOW IAW MM.SDR SWAA2014081530909Lens · brokenRIGHT BULLNOSE EMER LENS BROKEN AT ROW 16. REPAIRED LENS IAW MM.SDR SWAA2014081530907Flap · delaminatedLEFT WING INBD AFT FLAP DELAMINATED. R & R AFT FLAP IAW AMM.SDR SWAA2014081430843Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2014090931736Angle · crackedFORWARD CARGO COMPARTMENT ANGLE CRACKED AT BS 500B STRINGER 26L. REPLACED ANGLE IAW SRM & DWG.SDR SWAA2014090931735Frame · corrodedFRAME CORRODED AT BS 727E BETWEEN STRINGER 26L TO 27L. REPAIRED FRAME IAW SRM.SDR SWAA2014090931734Angle · crackedANGLE CRACKED AT BS 947.5, BETWEEN STRINGER 25R TO 24R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014090831634Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STRINGER 25R. R & R TIE CLIP IAW EA.SDR SWAA2014090431592Bear Strap · crackedAFT ENTRY DOOR CUT OUT BEAR STRAP CRACKED AT BS 947.5+11.5 STRINGER 17L. REPAIR CUT OUT IAW SRM.SDR SWAA2014090431586Frame · crackedSTUB FRAME CRACKED AT BS 951 BETWEEN STRINGER 16R TO 17R. REPAIRED STUB FRAME IAW EA.SDR SWAA2014090231525Tie Clip · corrodedTIE CLIP CORRODED AT BS 907 STRINGER 26R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014090231524Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D BETWEEN STRINGER 25L TO 26L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014090231519Fitting · crackedFORWARD CARGO COMPARTMENT CLIP CRACKED AT BS 380 STRINGER 26R. R & R CLIP IAW SRM & DWG.SDR SWAA2014090231518Fitting · crackedFORWARD CARGO COMPARTMENT CLIP CRACKED AT BS 380 STRINGER 26L. R & R CLIP IAW SRM & DWG.SDR SWAA2014090231513Skin · crackedL2 DOOR AFT UPPER CORNER CRACKED. REPAIRED CORNER IAW SRM.SDR SWAA2014082931428Channel · corrodedCHANNEL CORRODED AT BS 847+13 LBL 12.50. REPAIRED CHANNEL IAW EA.SDR SWAA2014082931427Channel · corrodedCHANNEL CORRODED AT BS 847+13 RBL 3.0. REPAIRED CHANNEL IAW EA.SDR SWAA2014082931426Channel · corrodedCHANNEL CORRODED AT BS 847+13 RBL 8.10. REPAIRED CHANNEL IAW EA.SDR SWAA2014082731294Angle · crackedANGLE CRACKED AT BS 500C STRINGER 26R. R & R ANGLE IAW SRM.SDR SWAA2014082631221Tie Clip · crackedTIE CLIP CRACKED AT BS 727A STRINGER 25L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014082631220Tie Clip · crackedTIE CLIP CRACKED AT BS 927 STRINGER 25R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014082631218Channel · crackedCHANNEL CRACKED AT BS 727 BL 0. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014082631212Window Frame · crackedLEFT BS 747+10 WINDOW FRAME CRACKED. R & R WINDOW IAW DWG.SDR SWAA2014082531148Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+9, RBL 24.5+17.5. REPAIRED WEB IAW SRM.SDR SWAA2014082531147Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+9 RBL 24.5+14.5. REPAIRED WEB IAW SRM.SDR SWAA2014082531146Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+2 RBL 24.5+14.5. REPAIRED WEB IAW SRM.SDR SWAA2014082531115Window Frame · crackedRIGHT BS 767+10 REMOVE WINDOW FRAME LOWER FWD CORNER CRACKED. R & R WINDOW IAW DWG.SDR SWAA2014082531163Angle · crackedANGLE CRACKED BETWEEN BS 927 TO 947.5, BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2014082131082Stringer Splice · crackedRIGHT BS 727+10 LOWER FWD WINDOW CORNER STRINGER SPLICE CRACKED. R & R SPLICE IAW DWG.SDR SWAA2014082131070Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+2, LBL 24.5+7.5. REPAIRED WEB IAW SRM.SDR SWAA2014082131069Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+9.5, LBL 24.5 +6. REPAIRED WEB IAW SRM.
Back to Boeing 737-3H4