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 SWAA2013103021692Flap Track · corrodedRT WING NR 7 FLAP TRACK CORRODED IN AREA WHERE IT MATES AGAINST THE WING SKIN & BOLT HOLES. R & R 7 FLAP TRACK IAW AMM.SDR SWAA2013102821602Support · looseLT WING NR 2 FLAP TRACK A FRAME FWD ATTACH POINT LOOSE. R &R SUPPORT ARM ASSEMBLY IAW MM.SDR SWAA2013102821601Flap Track · corrodedRT WING NR 7 FLAP TRACK CORRODED AT AFT ATTACH POINT. R & R NR 7 FLAP TRACK IAW MM & MT.SDR SWAA2013102821593Sign · looseLT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN IAW SIP.SDR SWAA2013102821514Plate · crackedLT WING TO BODY FAIRING ACCESS PANEL 33578L PLATE CRACKED. R & R PLATE IAW SRM & DRAWING.SDR SWAA2013112222702Pressure Panel · crackedMLG WW PRESSURE WEB UPPER CHORD CRACKED AT BS 663.75 TO BS 686, LBL 24.8. REPAIRED WEB IAW SWA EA.SDR SWAA2013112222701Pressure Panel · crackedMLG WW PRESSURE WEB UPPER CHORD CRACKED AT BS 663.75+3, LBL 24.8. REPAIRED WEB IAW SWA EA.SDR SWAA2013112222705Pressure Panel · crackedMLG WW PRESSURE WEB CRACKED AT BS 664.+1.75, LBL 24.5+7.75. REPAIRED WEB IAW SWA EA.SDR SWAA2013112222703Pressure Panel · crackedMLG WW PRESS WEB CRACKED AT BS 663.75, LBL 24.5. REPAIRED WEB IAW SWA EA.SDR SWAA2013112122647Skin · crackedRT WING INBD FIXED LE SKIN CRACKED AT LE STATION 208. REPAIRED SKIN IAW EA.SDR SWAA2013112122646Skin · crackedLT WING INBD FIXED LE SKIN CRACKED AT LE STATION 208. REPAIRED SKIN IAW EA.SDR SWAA2013112122643Keelbeam · corrodedRT SIDE KEEL BEAM CORRODED BETWEEN BS 707 TO BS 727. REPAIRED BEAM IAW EA.SDR SWAA2013112122642Keelbeam · corrodedLT SIDE KEEL BEAM CORRODED BETWEEN BS 707 TO BS 727. REPAIRED BEAM IAW EA.SDR SWAA2013102821501Lens · brokenFWD ENTRY DOOR EMERGENCY EXIT LIGHT LENS BROKEN. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2013110722026Forging · crackedRT BS 520+10 WINDOW FORGING CRACKED AT HOLE NR 7. R & R FORGING IAW BAC DRAWING.SDR SWAA2013102821536Battery · dischargedLT WING AFT EMERGENCY EXIT LIGHT INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2013112122641Frame · corrodedFRAME CORRODED AT BS 360, BETWEEN STRINGER 28L TO STRINGER 28R. REPAIRED FRAME IAW EA NO.SDR SWAA2013111822549Skin · crackedLT BS 520+10 UPPER FWD SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013111822519Skin · crackedRT BS 887+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 12. REPAIRED SKIN IAW EA.SDR SWAA2013111822503Panel · crackedAIR DISTRIBUTION PANEL ASSEMBLY CRACKED ABOVE RACK E1 IN EE COMPARTMENT. REPAIRED PANEL ASSEMBLY IAW EO & EA.SDR SWAA2013111822544Skin · crackedRT BS 400+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 4. REPAIRED SKIN IAW EA.SDR SWAA2013111222272Skin · crackedRT BS 500C+10 LOWER AFT SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013111222271Skin · crackedRT BS 500C+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3 -5. REPAIRED SKIN IAW EA.SDR SWAA2013111222287Skin · crackedRT BS 520+10 UPPER FORWARD SKIN CUTOUT CRACKED AT HOLES 5 & 7. REPAIRED SKIN IAW EA.SDR SWAA2013111222254Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 294.5, STRINGER 23L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013111122108Skin · crackedLT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 5. REPAIRED SKIN IAW EA.SDR SWAA2013111122107Skin · crackedLT BS 400+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3, 5, 6. REPAIRED SKIN IAW EA.SDR SWAA2013110521979Skin · crackedRT BS 500+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN IAW SB.SDR SWAA2013110521978Skin · crackedLT BS 500B+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013110521977Skin · crackedLT BS 380+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3, 6. REPAIRED SKIN IAW SB.SDR SWAA2013110521976Skin · crackedLT BS 420+10 UPPER FWD WINDOW CORNER CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013110521975Skin · crackedLT BS 380+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,10. REPAIRED SKIN IAW BOEING SB & TC.SDR SWAA2013110521999Skin · crackedLT BS 500A+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013110521891Skin · crackedLT BS 500+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013110521890Skin · crackedLT BS 480+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE 1,3,12. REPAIRED SKIN IAW EA.SDR SWAA2013110521889Skin · crackedLT BS 460+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013110521888Skin · crackedLT BS 360+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 1 & NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013110521887Skin · crackedRT BS 500A+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3,6. REPAIRED SKIN IAW EA.SDR SWAA2013110521886Skin · crackedRT BS 360+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 1,2,3. REPAIRED SKIN IAW EA.SDR SWAA2013110521885Skin · crackedLT BS 867+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB & TASK CARD.SDR SWAA2013110521884Skin · crackedRT BS 440+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1,2,3,12. REPAIRED SKIN IAW SB & TASK CARD.SDR SWAA2013110521881Skin · crackedRT BS 400+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,10. REPAIRED SKIN IAW EA.SDR SWAA2013110521880Skin · crackedRT BS 380+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB & TASK CARD.SDR SWAA2013110521879Skin · crackedRT BS 500B+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013110521878Skin · crackedLT BS 500C+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013110521877Skin · crackedLT BS 500+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013110521876Skin · crackedLT BS 460+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 10. REPAIRED SKIN IAW EA.SDR SWAA2013110521875Skin · crackedLT BS 440+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 2. REPAIRED SKIN IAW EA.SDR SWAA2013110521874Skin · crackedLT BS 420+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3,5. REPAIRED SKIN IAW EA.SDR SWAA2013110521873Skin · crackedLT BS 400+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3 & NR 2. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4