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 SWAA2012080306459Lens · looseLEFT OVERWING EMERGENCY EXIT SIGN LENS LOOSE. SECURED LENS PER MM.SDR SWAA2012080306458Stringer · corrodedSTRINGER CORRODED BETWEEN BS 352 TO BS 355, STR 28L. REMOVED AND REPLACED STRINGER IAW SRM.SDR SWAA2012080306457Wedge · puncturedRIGHT WING NR 6 SLAT UPPER SURFACE TRAILING EDGE WEDGE PUNCTURED. REPAIRED WEDGE IAW SRM.SDR SWAA2012080706544Shear Tie · corrodedSHEAR TIE CORRODED AT BS 520, BETWEEN STR 27L TO STR 28L. REMOVED & REPLACED SHEAR TIE IAW SRM.SDR SWAA2012080306435Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA2012073106368Lens · looseFORWARD OVERHEAD EMERGENCY EXIT SIGN LENS LOOSE. SECURED LENS PER MM.SDR SWAA2012082206881Skin · delaminatedLEFT WING NR 1 SLAT SKIN DELAMINATED. REPAIRED SKIN IAW SRM.SDR SWAA2012081506718Flap · delaminatedLEFT WING IB FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2012081506717Flap · delaminatedRIGHT WING FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2012081306653Skin · delaminatedLEFT WING NR 2 SLAT SKIN DELAMINATED. REPAIRED SKIN IAW SRM.SDR SWAA2012080106407Actuator · faultyAFTER TAKEOFF RIGHT MAIN LANDING GEAR WOULD NOT RETRACT. RED UNSAFE AND GREEN DOWN LIGHTS REMAINED ILLUMINATED WITH GEAR HANDLE IN OFF POSITION. CYCLED GEAR UP WITH NO CHANGE. CYCLED GEAR UP 2ND TIME. REMOVED AND REPLACED RIGHT MLG UPLOCK & DOWNLOCK ACTUATSDR SWAA2012073006281Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA2012080706567Channel · corrodedU-CHANNEL CORRODED AT BS 794, RBL 3.0. REPAIRED U-CHANNEL IAW EA.SDR SWAA2012073006333Sign · brokenFWD ENTRY DOOR EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA2012073006271Lens · missingLEFT EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA2012082306897Web · corrodedWEB CORRODED BETWEEN BS 360 TO BS 380, STR 17L. REMOVED AND REPLACED WEB IAW EA.SDR SWAA2012082006833Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012082006832Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 847+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012082006831Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012082006830Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012082006829Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 480+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012082006828Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 460+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012082006827Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 420+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012081706775Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012081606729Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 887+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012081606728Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012081506714Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012081506713Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 520+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012081506710Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 669, RBL 24.5. REPAIRED CHORD IAW EA.SDR SWAA2012081506709Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 665, RBL 24.5. REPAIRED CHORD IAW EA.SDR SWAA2012081306660Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 520+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012081306652Angle · crackedANGLE CRACKED BETWEEN BS 312 TO BS 344, STR 17L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012080806605Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 520+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080806604Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 360+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706552Skin · crackedFUSELAGE SKIN CRACKED AT FWD LEFT CORNER OF CONDITION AIR DOOR CUTOUT. REPAIRED SKIN IAW SRM.SDR SWAA2012080706551Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727C+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706550Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 460+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706549Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706548Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500C+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706547Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706546Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 460+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706545Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706543Skin · crackedFUSELAGE SKIN CRACKED AT BS 931, STR 25R. REMOVED AND REPLACED SKIN IAW SRM.SDR SWAA2012080706541Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 887+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706540Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706539Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 807+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706538Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706537Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727E+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706536Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727A+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706535Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 887+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4