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 SWAA2012062505179Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER M/M.SDR SWAA2012072306090Frame · crackedFRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME IAW EA.SDR SWAA2012072306089Skin · crackedSKIN CRACKED AT BS 520+2, STR 28R. REPAIRED SKIN IAW EA.SDR SWAA2012071905977Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 520+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012071905976Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 520+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012071905975Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 767+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012071905974Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012071605873Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012071605872Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 360+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012071605871Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012071605870Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 360+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012071605869Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB AND EA.SDR SWAA2012071605868Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727C+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012071605867Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727B+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012071605866Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 887+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012071605865Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012071605839Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727C+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012071305786Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 420+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012071305785Skin · crackedRIGHT FUSELAGE SKIN CRACKED A BS 500B+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012071205757Skin · crackedRIGHT FUSELAGE SKIN CRACKED BS 480+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIIN IAW SB.SDR SWAA2012071205756Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 460+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012071205755Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 440+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012071205754Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 480+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012071205753Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012071205752Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 887+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BS.SDR SWAA2012071205751Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727D+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012070905627Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500A+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012070905626Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012070905625Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012070905624Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500A+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012070905623Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 420+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012070905622Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 400+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012070905621Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012070905620Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012070905619Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012070905618Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012070905617Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012070905616Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 767+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012070905615Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012070905609Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 887+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012070905608Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012070905607Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012070905606Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727B+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012070905605Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 867+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012070905604Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012070905603Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 847+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012070905601Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012070505541Frame · crackedFUSELAGE FRAME CRACKED AT BS 500B, STR 20R TO STR 21R. REPAIRED FRAME PER EA.SDR SWAA2012070505540Frame · crackedFUSELAGE FRAME CRACKED AT BS 500B, STR 19R TO STR 22R. REPAIRED FRAME PER EA.SDR SWAA2012070505539Frame · crackedFUSELAGE FRAME CRACKED AT BS 500B, STR 20L TO STR 21L. REPAIRED FRAME PER EA.
Back to Boeing 737-3H4