Boeing 737-7Q8
Service difficulty reports · 3,964
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 = '7377Q8' 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 = '7377Q8' 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 AUS20040503Pump · leaking(AUS) NR 2 ENGINE DRIVEN HYDRAULIC PUMP LEAKING.SDR AUS20040483Engine · bird strike(AUS) NR 2 ENGINE BIRDSTRIKE. INSPECTION FOUND EVIDENCE OF BIRD REMAINS IN BOOSTER.SDR AUS20040397Separator · contaminated(AUS) AIR CONDITIONING SYSTEM DUCTING, WATER SEPARATORS AND COALESCER BAGS CONTAMINATED WITH OIL. SUSPECT CAUSED BY OVERFILLING OF APU OIL SYSTEM.SDR SWAA041309Battery · inoperativeDURING SCHEDULED MV1 CHECK, FOUND EMERGENCY EXIT LIGHTS AT LT OVERWING EXIT AND OVERHEAD CEILING, INOP. REMOVED AND REPLACED EMERGENCY EXIT LIGHT BATTERY PER MM.SDR AUS20040432Nipple · cracked(AUS) LT THRUST REVERSER OIL SCAVENGE LINE NIPPLE CRACKED.SDR AUS20040293Motor · faulty(AUS) STABILIZER ELECTRIC TRIM MOTOR FAULTY.SDR AUS20040275Fuel Tank · leaking(AUS) LT WING FUEL TANK LEAKING INTO DRY BAY AT WBL 616.75 LOWER AFT CORNER.SDR SWAA040293Battery · inoperativeDURING SCHEDULED MC, FOUND MID-CABIN EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA040175Battery Pack · inoperativeDURING SCHEDULED MC, FOUND OVERWING EMERGENCY EXIT LIGHTS INOP AT CEILING AND LT OVERWING EXIT DOOR. REMOVED AND REPLACED BATTERY PACK PER MM.SDR AUS20040016Spring · missing(AUS) LT MAIN LANDING GEAR AFT UPLOCK SPRING MISSING.SDR AUS20031289Connector · loose(AUS) ENGINE CONNECTOR D11286 NOT CONNECTED. CONNECTOR WAS SITTING ON TOP OF THE RECEPTACLE.SDR AUS20031243Motor · failed(AUS) STABILIZER TRIM MOTOR FAILED.SDR AUS20031319Pump · failed(AUS) ELECTRIC FUEL PUMP FAILED INSPECTION IAW AD/737/198/BORO. FOUND USING BOROSCOPE AND X-RAY INSPECTION.SDR AUS20031153B-Nut · loose(AUS) NR 2 ENGINE REAR SUMP OIL PRESSURE LINE B-NUT LOOSE. LOOSE UNION IS LOCATED AT 6 O'CLOCK POSITION JUST OB OF THE ENGINE LUBRICATION UNIT.
Back to Boeing 737-7Q8