Boeing 737-824
Service difficulty reports · 9,839
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 = '737824' 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 = '737824' 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 CALA2017081102593Clamp · brokenCREW REPORTED SHORTLY AFTER TAKE OFF, THE NR 1 ENGINE OIL QTY DROPPED TO ZERO WITH ASSOCIATED LOSS OF OIL PRESSURE. IFSD PERFORMED. EMERGENCY DECLARED. FOUND STARTER CLAMP BROKEN. AS A PERCAUTION, REMOVED, REPLACED, AND SERVICED THE STARTER IAW AMM 80-11SDR CALA2017081102595Indicator · inaccurateFIRST OFFICER`S ALTIMETER INACCURATE BY 1000 FT DURING FLIGHT, AND DESCENT. IAW AMM 34-11-00-790-806, PERFORMED LEAK CHECK OF THE FIRST OFFICER`S AND CAPTAIN`S STATIC SYSTEM, NO LEAKS FOUND.SDR CALA2017081102594Unknown · odorODOR IN CABIN AND COCKPIT. EMERGENCY DECLARED. THERE WAS NO VISIBLE SMOKE, JUST THE ODOR OF OIL IN CABIN AND COCKPIT FOR A FEW MINUTES THEN DISSIPATED. PERFORMED AMM 05-51-26-800-801 AND COULD NOT DUPLICATE. TOOK AIRCRAFT OUT FOR POWER RUN AND NO FAULTS WESDR CALA2017081102586Slide · partial deployR1 DOOR SLIDE PARTIALLY DEPLOYED. R & R THE L1 DOOR SLIDE IAW MM 25-66-01-400-801. OPS CHECKED GOOD. NO DEFECTS NOTEDSDR CALA2017081102585Engine · fodWHILE SITTING ON TAXIWAY, THE ENGINE INGESTED HUGE PIECE OF ROLLING PLASTIC. THE ENGINE FAILED, PERFORMED A VISUAL FOD INSPECITON OF THE NR 1 ENGINE IAW AMM 71-00-00-800-802-F00. FOUND NO EVIDENCE OF PLASTIC INDGESTION INSIDE ENGINE CORE, FOUND AND REMOVEDSDR CALA2017080802580Battery Pack · dischargedEMERGENCY LIGHTS AT BAG BIN AREA ROW 21,23,25,28 INOP. REMOVED AND REPLACED BATTERY PACK AT LOCATION M1671. OPS CHECK GOOD REF AMM 335106 VERIFIED BATTERY PACK REPLACED AND EMERGENCY PATH LIGHTING OPERATIONAL CHECK REF AMM 33-51-06.SDR CALA2017080802573Light · missingRED COVER FOR EXIT ROW LIGHTS 15ABC MISSING. REPLACED EMERGENCY LIGHT IAW AMM 33-51-11.SDR CALA2017080802565Sign · unsecureEMERG EXIT SIGN MID CABIN FELL OFF. REINSTALLED EMERG EXIT SIGN MID CABIN REF AMM25-60.SDR CALA2017080802558Light · brokenON SEAT 20C. THE RED LIGHT THAT SHOWS THE EMERGENCY EXIT HAS BEEN BROKEN OFF. REPLACED RED LIGHT FOR EMERGENCY EXIT IN SEAT 20C.SDR CALA2017080802550Flashlight · inoperativeEMERGENCY FLASHLIGHT AFT CABIN INOPERATIVE. REMOVED AND REPLACED AFT CABIN EMERGENCY FLASHLIGHT IAW AMM 25-64-00.SDR CALA2017080802541Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE AFT OF LT EXIT HATCH EXTERIOR. REPLACED THE LAMP, OPS CHECKED GOOD.SDR CALA2017080802540Lamp · inoperativeEMERGENCY EXIT LIGHT AT SEAT 22 ABC BULL NOSE INOPERATIVE. REPLACED THE LAMP, OPS CHECKED GOODSDR CALA2017080802557Sign · detachedOVERWING EMERGENCY EXIT SIGN FELL OFF. SECURED THE SIGN.SDR CALA2017080802542Cover · missingSEAT ROW 15C RED EMERGENCY LIGHT COVER IS MISSING. INSTALLED THE COVER.SDR CALA2017080802521Motor · faultySTAB OUT OF TRIM LIGHT LIGHT ILLUMINATED. EMERGENCY DECLARED. TROUBLESHOT THE STAB TRIM AND FOUND STAB TRIM MOTOR AT FAULT. REMOVED AND REPLACED STAB TRIM MOTOR IAW AMM 27-41-71-400-801. STAB TRIM WORKS NORMAL.SDR CALA2017080802498Interlock Valve · faultyLANDING GEAR LEVER DOES NOT MOVE TO THE UP POSITION IN FLIGHT, IS FREE TO MOVE TO THE UP POSITION WHEN THE LOCK OVERRIDE IS USED. EMERGENCY DECLARED. PSEU BITE CHECK INDICATED GROUND SPOILER INTERLOCK VALVE FAILURE. INSTALLED GROUND SPOILER INTERLOCK IAW 27SDR CALA2017080702465Unknown · odorDURING TAXI INBOUND, STARTED THE APU. A STRONG ELECTRICAL BURNING ODOR, WITH APU OFF, NO ODOR. PERFORMED VISUAL INSPECTION OF TAILCONE AREA AND ADJACENT CONTROL SURFACES NO EVIDENCE OF HEAT DAMAGE. INSPECTED APU, NO OBVIOUS DAMAGE NOTED. RAN APU AND LOOKSDR CALA2017080802509Rib · crackedLEFT HORIZONTAL STABILIZER RIB AT HSS 120 HAS A CRACK AT SECOND STIFFENER FROM THE FRONT. INSTALLED A REPAIR IAW SRM 55-10-09, FIG 202, REPAIR 4.SDR CALA2017080802466Rib · crackedLEFT HORIZONTAL STABILIZER RIB AT HSS 120 HAS A CRACK AT THIRD STIFFENER FROM THE FRONT. INSTALLED A REPAIR IAW SRM 55-10-09, FIG 202, REPAIR 4.SDR CALA2017073002450Wire · disconnectedEMERGENCY LIGHT AT SEAT 32C INOP. RECONNECTED WIRE AT SEAT TO FLOOR CONNECTION. OPS CK GOOD. REF WDM 33-51-22 C/W IDT INSPECTION REF GMM 09-10-05.SDR CALA2017073002449Fuse · blownEMERGENCY LIGHTS AT SEAT AREA 25 & 28DEF BULLNOSE ARE INOP. RELAMPED NO HELP. REPLACED FUSE AND OPS CK GOOD. REF AMM 33-51-03-960-801 AND IPC 33-51-06-02 C/W IDT INSPECTION REF 09-10-05.SDR CALA2017072902428Wire Harness · faultyENGINE OVERTEMPERATURE (EXCEPT STARTING) EGT OVER AMBER BAND LIMIT, NO SURGE/STALL ENGINE 2 ON DEPARTURE EGT WENT TO 950 RED BOX FOR 10 SECS. TROUBLESHOT PER FIM 77-21-00-810-801-FOO. NR 2 ENGINE TOP RIGHT EGT SIGNAL OUT OF RANGE. REMOVED AND REPLACED NR 2 ENGSDR CALA2017072902432Lens · looseEMER EXIT SIGN AT EXIT. SECURED LENS.SDR CALA2017072902431Light · missingEMERGENCY EXIT ROW PATH LIGHTING MISSING BULB. REPLACED LIGHT ASSEMBLY.SDR CALA2017072802420Slide · partial deployPARTIAL SLIDE DEPLOYMENT AT 1L. . REMOVED AND REPLACED L1 SLIDE ASSY PER AMM 25-66-01-000-801, -4 00-803, 25-66-01-000-802, -400-801. CHECKS GOOD. A/C OK FOR SERVICESDR CALA2017072802418Lens · unsecureEXIT SIGN FELL OFF DOOR 2L . INSTALLED SERVICEABLE EMERGENCY EXIT LENS.SDR CALA2017072402368Cover · missingL2 DOOR LIGHT MISSING THE WHITE PLASTIC COVER. REPLACED THE EXIT SIGN IAW AMM 33-51-01. OK FOR SERVICE.SDR CALA2017072402364Girt Bar · looseL1 DOOR SLIDE GIRT BAR BRACKET LOOSE. ADJUSTED THE GIRT BAR HOLDING CLAMPS, OK TO CONTINUE.SDR CALA2017072402362Lens · missingROW 2 EMERGENCY LIGHT LENS IS MISSING. INSTALLED ROW 2 EMERGENCY PROXIMITY LIGHT LENS IAW IFM 25-27-42.SDR CALA2017072402367Lens · missingEMERGENCY LIGHT COVER MISSING AT THE R2 DOOR. REPLACED LENSSDR CALA2017072402366Lens · missingRED EMERGENCY LIGHT LENS AT SEAT 20C MISSING. REPLACED THE LIGHT ASSY IAW 33-51-11.SDR CALA2017072402363Sign · looseCEILING EMERGENCY EXIT SIGN IS LOOSE.SDR CALA2017072402348Skin · crackedLEFT HORIZONTAL STAB LOWER SKIN CRACKED JUST INBD OF RIB HSS 147. 7 AND 32.5 INCHES FROM FWD SPAR. CRACK LENGTH IS 1 INCH. VERIFIED BY HFEC. INSTALLED CATEGORY B REPAIR IAW SRM 55-10-01, REPAIR 11.SDR CALA2017072402347Skin · crackedLEFT HORIZONTAL STAB LOWER SKIN CRACKED JUST INBD OF RIB HSS 184. 7 AND 27.5 FROM FWD SPAR. CRACK LENGTH IS 1 INCH. VERIFIED BY HFEC. INSTALLED A REPAIR IAW SRM 55-10-01, REPAIR 11.SDR CALA2017072102327Lens · missingEMERGENCY PATH LIGHT ON LOWER BULKHEAD IN FRONT OF SEAT 2B IS MISSING ITS COVER. INSTALLED NEW LENS CAP, LIGHT OPS CKS OK.SDR CALA2017072102326Cover · loose20A EMERGENCY EXIT COVER DOESNT STAY ATTACHED. SECURED COVER.SDR CALA2017072102325Battery · dischargedAFT EMERGENCY FLASHLIGHT NEEDS REPLACED. REPLACED AFT OB FLASHLIGHT BATTERY. CKS OK.SDR CALA2017072102287Probe · malfunctionedNR 2 ENGINE OVERHEAT LIGHT, EGT LIMITS EXCEEDED ON TAKE OFF. RANG WIRES FROM DP1012 CONTACTS A,B TO DP1010 CONTACTS B,U. CHECKED SECURE. CJ10 HARNESS AND SAFETY WIRED TEMP PROBE CHECKED FOR CONTINUITY, SHORTS TO EACH OTHER AND SHORTS TO GROUND RE PER AMM 77-SDR CALA2017071702272Sign · unsecureEMERGENCY EXIT SIGN HAS FALLEN OFF. PLACED EMERGENCY SIGN BACK TO ITS PROPER PLACE.SDR CALA2017071702257Trim Motor · faultySTABILIZER TRIM SWITCHES DO NOT OPERATE TRIM UP AND TRIM DOWN CAPTAIN’S. EMERGENCY DECLARED. REMOVED AND REPLACED STAB TRIM ELECTRIC MOTOR IAW AMM 27-41-71-400-801 OPS CHECK GOOD PER AMM 27-41-700-801.SDR CALA2017071402240Latch · dirtyDOOR 1L GIRT BAR LEFT SIDE RETAINING CLIP DOES NOT FREELY ACCEPT GIRT BAR. REMOVED DEBRIS FROM LATCH, OPS CKS GREAT.SDR CALA2017071402239Cover · unsecureOVERWING EXIT COVER SIGN FELL OFF. RESECURED CENTER ISLE OVERWING EMERGENCY EXIT SIGN, OPS CKS GOOD ACFT OK TO CONTINUE.SDR CALA2017071402238Flashlight · inoperativeFA FLASHLIGHT DEAD FORWARD STATION. REPLACED OUTBD EMERGENCY FLASHLIGHT AT DOOR 1L IN REF TO AMM 25-64-00-200-802. OPS CKS GOOD.SDR CALA2017071402237Light · inoperativeEXTERIOR EMERGENCY LIGHT INOP AT A/C LEFT AFT OVERWING HATCH DOOR. RELAMPED EXTERIOR EMERGENCY LIGHT AT A/C LEFT AFT OVERWING DOOR HATCH. OPS CHECK GOOD.SDR CALA2017071002169Connector · damagedEMERGENCY EXIT LIGHT AT SEAT 25C WILL NOT ILLUMINATE. FOUND A PIN PUSHED IN ON THE INBOARD LEG SEAT CONNECTOR. RESEATED THE PIN. EMERGENCY LIGHT OPS CHECKED GOOD IAW WDM33-51-22-010-01, PG11.SDR CALA2017071002168Battery Pack · inoperativeEMERGENCY LIGHTS AT SEATS 20 THRU 28 DEF JUST BELOW OVERHEAD BINS INOPERATIVE WHEN SELECTED ON. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-5 1-06. LIGHTS OP CHECKED GOOD.SDR CALA2017071002167Lens · missingEMERGENCY EXIT LIGHT LENS MISSING AT ROW 21DEF. R & R EMERGENCY EXIT LIGHT ASSY. OPS CHECKED NORMAL. OK TO CONTINUE IN SERVICE.SDR CALA2017071002166Lamp · inoperativeEMERGECY EXIT LIGHTS AT ROW 20 ARE INOPERATIVE. REPLACED TEH LAMPS. OPS NORMAL.SDR CALA2017070702099Skin · wornLOWER FUSELAGE E&E DOOR EXTERIOR SKIN WAS WORN METAL. FOUND OUT OF LIMITS. INSTALLED REPAIR DOUBLER REF SRM 52-00-01 REPAIR 3.SDR CALA2017070202084Lens · brokenSEAT 32C EMERGENCY LIGHT HAS BROKEN LENS REPLACED EMERGENCY LIGHT ASSY AS REQUIRED. OPS CHK GOOD.
Back to Boeing 737-824