Boeing 737-4Q8
Service difficulty reports · 6,250
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 = '7374Q8' 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 = '7374Q8' 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 ASA0440257Frame · corrodedPAE - FOUND CORROSION ON AFT CARGO BAY, FRAME, FORWARD LOWER ANGLE. REPAIRED DAMAGED FAIL/SAFE L-ANGLE, FABRICATED REPAIR PARTS AND INSTALLED. (M)SDR ASA0440258Frame · damagedPAE - FOUND MECHANICAL DAMAGE ON FRAME. REPAIRED FRAME. (M)SDR ASA0440264Floor Support · corrodedPAE - FOUND CORROSION ON FLOOR SUPPORT. REPLACED FLOOR SUPPORT. (M)SDR ASA0440237Floor Support · corrodedPAE - FOUND FLOOR SUPPORT CORRODED. REPAIRED PER EA. (M)SDR ASA0440236Floor Support · corrodedPAE - FOUND AFT CARGO FLOOR SUPPORT CORRODED. REPAIRED PER EA. (M)SDR ASA0440238Web · dentedPAE - FOUND FORWARD CARGO DOOR CUTOUT, LOWER FORWARD CLOSE OUT WEB DENTED. REPAIRED PER SRM. (M)SDR ASA0440245Skin · dentedPAE - FOUND SKIN DENTED. REPAIRED PER SRM. (M)SDR ASA0440247Floorbeam · corrodedFOUND CORROSION FUSELAGE UPPER LOBE, FLOORBEAM UPPER FLANGE IS CORRODED. REPLACED FLOORBEAM. (M)SDR ASA0440248Floorbeam · corrodedFOUND CORROSION FUSELAGE UPPER LOBE, FLOORBEAM UPPER FLANGE IS CORRODED. REPLACED FLOORBEAM. (M)SDR ASA0440246Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM UPPER FLANGE. REPAIRED PER SRM. (M)SDR ASA0440249Intercostal · crackedPAE - FOUND INTERCOSTAL CRACKED. REPAIRED PER SRM. (M)SDR ASA0440250Structure · dentedPAE - FOUND DENT IN EDGE OF LIGHTING HOLE, FORWARD CARGO DOOR INNER SURFACE AT UPPER FORWARD CORNER. CUTOUT DAMAGED AREA, FABRICATED REPAIR PARTS AND INSTALLED. (M)SDR ASA0440251Web · dentedPAE - FOUND DENT IN FORWARD CARGO INNER WEB. FABRICATED REPAIR PARTS AND INSTALLED. (M)SDR ASA0440240Stringer Clip · crackedPAE - FOUND STRINGER CLIP CRACKED. REPAIRED PER SRM. (M)SDR ASA0440242Stringer Clip · crackedPAE - FOUND CRACKED STRINGER CLIP. REPLACED PER SRM. (M)SDR ASA0440241Fitting · gougedPAE - FOUND LOWER AFT LATCH FITTING FOR ASD GOUGED. REPLACED PER SRM. (M)SDR ASA0440244Angle · crackedPAE - FOUND UPPER LOBE, ANGLE CRACKED. REPLACED PER SRM. (M)SDR ASA0440243Stringer Clip · crackedPAE - FOUND CRACKED STRINGER CLIP. REPAIRED PER SRM. (M)SDR ASA0440239Floor Support · corrodedPAE - FOUND CORROSION ON FLOOR SUPPORT. REPAIRED AND REPLACED PART PER SRM. (M)SDR ASA0440235Skin · crackedRT HORIZONTAL STABILIZER, LOWER SKIN CRACKED 2 INCHES FWD OF BREAK SPAR. REPAIRED CRACK IAW EA.SDR ASA0440234Skin · dentedLT WING LOWER EXTERIOR SKIN IS DENTED. REPLACED LOWER EXTERNAL SKIN IAW SRM.SDR ASA0440218Splice · misdrilledMISDRILLED STRINGER SPLICE. REPLACED STRINGER SPLICE.SDR ASA0440225Floorbeam · damagedOVERSIZED HOLES IN LOWER FLANGE OF FLOORBEAM. REPAIRED FLOORBEAM.SDR ASA0440224Shear Tie · corrodedCORRODED SHEAR TIE. REPAIRED WITH DOUBLER.SDR ASA0440223Skin · damagedDOUBLE HOLE DRILLED IN SKIN AND BEARSTRAP. REAMED UP HOLE AND INSTALLED DOUBLER.SDR ASA0440222Skin · corrodedCORRODED INNER SKIN AFT OF AFT CARGO DOOR. REMOVED CORROSION AND INSTALLED DOUBLER.SDR ASA0440221Skin · corrodedCORROSION ON INNER SKIN FORWARD OF AFT CARGO DOOR. REMOVED DAMAGE, INSTALLED DOUBLER.SDR ASA0440220Skin · gougedGOUGES IN SKIN. BLENDED GOUGED SKIN, AND INSTALLED DOUBLER.SDR ASA0440219Skin · gougedNUMEROUS GOUGES ON SKIN BELOW AFT CARGO THRESHOLD. BLENDED GOUGED SKIN, FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0440218Splice · damagedDAMAGED STRINGER SPLICE. REPLACED STRINGER SPLICE.SDR ASA0440217Stringer Clip · crackedSTRINGER CLIP CRACKED. REPLACED STRINGER CLIP.SDR ASA0440216Frame · crackedFRAME IS CRACKED AT LT OVERHEAD BIN RAIL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440215Frame · crackedFRAME IS CRACKED AT RT OVERHEAD BIN RAIL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440214Frame · crackedFRAME IS CRACKED AT RT OVERHEAD BIN RAIL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440213Frame · crackedFRAME IS CRACKED AT LT OVERHEAD BIN RAIL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440212Frame · crackedFRAME IS CRACKED AT LT OVERHEAD BIN RAIL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440211Frame · crackedFRAME IS CRACKED AT LT OVERHEAD BIN RAIL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440210Frame · crackedFRAME IS CRACKED AT LT OVERHEAD BIN RAIL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440209Frame · crackedFRAME IS CRACKED AT RT OVERHEAD BIN RAIL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440208Frame · crackedFRAME IS CRACKED AT RT OVERHEAD BIN RAIL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440207Frame · crackedFRAME IS CRACKED AT LT OVERHEAD BIN RAIL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440206Frame · crackedFRAME IS CRACKED AT LT OVERHEAD BIN RAIL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440205Frame · crackedFRAME IS CRACKED AT LT OVERHAND BIN CHANNEL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440204Frame · crackedFRAME IS CRACKED AT RT OVERHAND BIN CHANNEL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440203Frame · crackedFRAME IS CRACKED AT LT OVERHAND BIN CHANNEL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440202Frame · crackedFRAME IS CRACKED AT RT OVERHAND BIN CHANNEL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440201Frame · crackedFRAME IS CRACKED AT LT OVERHAND BIN CHANNEL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440200Frame · crackedFRAME IS CRACKED AT LT OVERHEAD BIN CHANNEL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440199Frame · crackedFRAME IS CRACKED AT RT OVERHAND BIN CHANNEL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.SDR ASA0440198Frame · crackedFRAME IS CRACKED AT RT OVERHAND BIN CHANNEL SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW EA.
Back to Boeing 737-4Q8