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 jasc_code = '2612' 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 jasc_code = '2612' 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 20000329SH039Warning Light · illuminatedEN ROUTE, RIGHT ENGINE FIRE WARNING LIGHT ILLUMINATED BRIEFLY. DIVERTED FLIGHT. FALSE ENGINE FIRE WARNING, CHAFED WIRE. (X)SDR 2000UALA00105Fire Detector · shortedTHE NR 2 ENGINE OVERHEAT LIGHT ILLUMINATED. THE INDICATION EXTINGUISHED AND ILLUMINATED INTERMITTENTLY. *S/D* THE CORE DETECTION LOOP (M1122) SHORTED TO BOTH A AND B LOOPS. REPLACED BOTH LOOPS, CONTROL MODULE (M279) AND FIRE BOTTLES. PERFORMED HIGH POWERSDR CA000404005Fire Detector · shorted(CAN) THE CREW REPORTED THAT DURING FLIGHT THE LEFT ENGINE FIRE WARNING CAME ON INTERMITTENTLY. THE LIGHT INDICATION OCCURS ONLY AFTER PRECIPITATION OR AIRCRAFT WASHING. FOUND FIRE DETECTOR TRIGGER VOLTAGE LEAKING THROUGH WIRE INSULATION WHEN IT IS WET.SDR WRLA20008Harness · chafedON 2/29/2000, DURING CLIMB-OUT AFTER DEPARTING OEJN, THE AIRCRAFT HAD AN ENGINE NR 3 LEVEL 3 FIRE ALERT. THE CREW BROUGHT THE ENGINE BACK TO IDLE AND THE ALERT WENT AWAY. STANDARD EMEGENCY PROCEDURES WERE COMPLIED WITH AND THE AIRCRAFT RETURNED TO THE DEPARTSDR 20000405AP003Fire Loop · out of positionFLT 719 - PHX-IND - NR 3 GROUND FAULT DETECTOR LIGHT ILLUMINATED IN FLIGHT. REPOSITIONED FIRE LOOP. (M)SDR 20000405AP002Fire Loop · out of positionFLT 615 - PIT-PHL - NR 3 GROUND FAULT LIGHT ON. DEFERRED IN PIT, CLEARED IN PHL. REPOSITIONED FIRE LOOP. (M)SDR CA000328015Computer · failed(CAN) CARGO FIRE WARNING ON EICAS AP 410 FT AND SMOKE IN CABIN AFTER FIRE DRILL WITH NR 1 FIRE BOTTLE DISCHARGED IN CARGO BAY. SUSPECT DISCHARGE INTO BAY WAS SMOKE IN CABIN. REPLACED EICAS COMPUTER.SDR RAIA0002015Controller · failed7395 - MWA - ON TAXI OUT, RIGHT ENGINE FIRE INDICATION ILLUMINATED. MAINTENANCE INSPECTED AND FOUND NO EVIDENCE OF FIRE, REPLACED RIGHT ENGINE FIRE WIRE CONTROLLER.SDR USAASB00045Fire Loop · malfunctionedCLT - FLT 7031 - EN ROUTE FROM TPA-BOS, THE NR 1 ENGINE FIRE DETECTION FAULT LIGHT BEGAN TO ILLUMINATE INTERMITTENTLY TO STEADY. CREW ACCOMPLISHED QUICK REFERENCE HANDBOOK PROCEDURES AND DIVERTED TO CLT. FLIGHT LANDED WITHOUT FURTHER INCIDENT. NO EMERGENCY SDR AWXA0000091Fire Detector · malfuntionedNR 2 ENGINE FIRE LIGHT AND MASTER FIRE LIGHT INDICATED FIRE, NO ECAM, NO MASTER WARNING. ENGINE 2 SHUTDOWN IN-FLIGHT AND BOTH FIRE BOTTLES FIRED. REMOVED AND REPLACED NR 2 FIRE DETECT UNIT, OPS CK GOOD. TT 0003704 M+E = 26-2612-9-0001. REPLACED NR 1 AND 2SDR 00FDEA00087Fire Detector · malfunctionedMAIN CARGO LOOP DETECTION FAULT ILLUM ON ECAM. TEST MAIN CARGO DECK SMOKE DETECTION SYSTEM PER AMM 26-19-00-5. OPS CK GOOD. SUSPECT FAULT CAME FROM DRY ICE SHIPMENT ON CARGO DECK.SDR 0000489610Fire Detector · malfunctionedAFTER TAKEOFF, CARGO FIRE DETECTION SYSTEM A INDICATED A FIRE IN THE FORWARD CARGO HOLD. THE AIRCRAFT HAD CARGO FIRE DETECTION SYSTEM B ON MEL, SO THE CREW DID NOT HAVE SECONDARY VERIFICATION CAPABILITY. THE CREW DISCHARGED THE FORWARD CARGO AREA FIRE EXTINGSDR CALA0000158Warning System · activatedTHE MASTER CAUTION LIGHT, OVERHEAT/DETECT LIGHT, AND CARGO DETECTION SUPRESSION FAIL LIGHT ILLUMINATED WHILE EN ROUTE FROM IAH TO SJC. THE AIRCRAFT WAS DIVERTED TO PHX WHERE IT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND NO EVIDENCE OF FIRE. THE FIRE AND SMOKSDR UIEA0004Fire Loop · inoperativeFLT 6137 - AMS-DXB - NR 2 ENGINE FIRE WARNING FAULT LIGHT CAME ON DURING THE TAKEOFF ROLL, ''B'' LOOP INDICATED 8 UNITS. WHEN AIRCRAFT BLOCKED IN, NR 2 ENGINE ''B'' LOOP FIRE WARNING READ 8 UNITS. FOR TROUBLESHOOTING FIRE WARNING CARDS WERE SWAPPED, BUT NO HSDR PNSA000201Warning Light · illuminatedLT ENGNIE FIRE LIGHT ILLUMINATED ON TAKEOFF.SDR 2000ZZZM199Fire Loop · misroutedFLT 711 - EWR-IND - FIRE DETECTION B-LOOP LIGH TON NR 3 ENGINE. REROUTED NR 3 ENGINE GROUND LOOP. (M)SDR 2000ZZZM198Fire Loop · out of positionFLT 619 - PHX-SAN - NR 1 GROUND FAULT LIGHT ON. DEFERRED IN SAN, CLEARED IN IND. REPOSITIONED THE NR 1 GROUND FAULT FIRE WARNING LOOP. (M)SDR CA000209007Fire Loop · chafed(CAN) APU FIRE WARNING CAME ON DURING CLIMB FIRE BOTTLE DISCHARGED AND STILLWARNING ON A/C RETURNED. FOUND WIRING CHAFFED AND SHORTED BENEATH SUPPORT CLAMP. REPAIRED.SDR USAABB00012Fire Detector · malfunctionedIAD - FLT 106 - EN ROUTE PHL-SEA - CREW RECEIVED THE FIRE INDICATION FROM THE LEFT ENGINE. CAPTAIN REDUCED THE THROTTLE AND THE INDICATION PERSISTED. FUEL WAS SHUT OFF AND BOTH ENGINE FIRE BOTTLES WERE ACTIVATED. THE LIGHT EXTINGUISHED AFTER THE SECOND BOTTSDR 00FDEA00050Fire Detect Sys · malfunctionedFIRE LIGHT ON THE NR 3 ENG WITH THE FIRE BELL. RED TABS LED US TO DISCHARGE BOTH FIRE BOTTLES AND LIGHT REMAINED ON. REMOVED AND REPLACED NR 3 ENG ELEMENT PER FEDEX 727-200 MM 26-11-012-4. PRECAUTIONARY REMOVED AND REPLACED ENG FIRE PROTECT CTR & FIRE BOTTLSDR 2000ZZZM230Fire Loop · out of positionFLT 635 - DSM - NR 2 FIRE WARNING GROUND FAULT DETECTOR LIGHT ON. GOES OFF WHEN SYSTEM IS TESTED. DEFERRED IN DSM, CLEARED IN IND. REPOSITIONED NR 2 GROUND FAULT FIRE WARNING LOOP. (M)SDR 2000ZZZM200Fire Loop · out of positionFLT 710 - MSP-IND - NR 3 GROUND FAULT LIGHT ON. DEFERRED IN IND, CLEARED IN MCI. FOUND NR 3 ENGINE FIRE LOOP CHAFING LOWER COWL IN 2 PLACES. REPOSITIONED LOOP. (M)SDR GAIA00046Fire Detector · malfunctionedMHR/LAX - FLT 2031 - DURING CRUISE, THE APU FIRE WARNING LIGHT ILLUMINATED. THE CREW PERFORMED ABNORMAL CHECK LIST AND DECLARED AN EMERGENCY AND RETURNED TO MHR. THE AIRCRAFT LANDED SAFELY WITHOUT ANY INCIDENT. VISUALLY INSPECTED APU AND SHROUD FOR EVIDENCESDR 2000ZZZM201Fire Loop · out of adjustFLT 713 - GSO-CLT - NR 2 ENGINE FIRE DETECTOR LOOP LIGHT ILLUMINATED ON ENGINEERS PANEL. DEFERRED IN CLT, CLEARED IN EWR. FOUND SENSOR TOUCHING BRACKET ADJUSTED SENSOR AND LIGHT WENT OUT. (M)SDR 2000ZZZM191Fire Loop · out of positionFLT 9002 - IND-SAT - NR 3 ENGINE FIRE DETECTOR GROUND CIRCUIT LIGHT ON. DEFERRED IN SAT, CLEARED IN IND. REPOSITIONED FIRE LOOP ON NR 3 ENGINE. (M)SDR 00FDEA00045Harness · malfunctionedDURING ROLLOUT FIRE ALERT NR 1 ENG. ACCOMPLISHED ENG FIRE CKLIST, USED AGENT 1. AGENT 2 WOULD NOT FIRE. REMOVED AND REPLACED LT AND RT FIRE DET HARNESSES REF MM 71-50-04-4. NR 1 ENG FIRE WARN TEST OK PER MM 26-11-02-5. SEE MTSI 26-11-3714 FOR ADD'L INFO.SDR SWAA000174Fire Detector · erraticINFLIGHT ENGINE SHUTDOWN, NR 1 ENGINE OVERHEAT LIGHT ILLUMINATED. C/W QRH PROCEDURES AND DISCHARGED BOTH FIRE EXTINGUISHER BOTTLES. REMOVED AND REPLACED NR 1 ENG LOWER FIRE/OVERHEAT DETECTOR AND FIRE BOTTLES PER MM.SDR DLM11000223Smoke Detector · malfunctionedIN CRUISE, LAVATORY SMOKE ALERT ILLUMINATED FOR LAV H. CLOSE VISUAL INSP IN LAV COMPARTMENT SHOWED NO SMOKE, NO HEAT OR EXTINGUISHING AGENT DISCHARGE. PULLED AND RESET LAV H SMOKE DETECTOR CB AND SYS SMOKE DET CB AT 1L. ALERT RETURNED WHEN CBS RESET. VERIFSDR 2000UALA00039Fire Loop · shortedTHE AIRCRAFT DIVERTED DUE TO AN AMBER ALERT ON THE AUXILIARY POWER UNIT FIRE INDICATION. *S/D* THE LOWER LOOP M334 SHORTED TO GROUND. REPLACED THE LOWER LOOP M334 AND AUXILIARY POWER UNIT FIRE BOTTLE.SDR DL72W000222Smoke Detector · malfunctionedLAV SMOKE LIGHT ON S/O PANEL CAME ON INTERMITTENTLY DURING CLIMBOUT WITH NO INDICATIONS OF SMOKE. REPEAT WRITEUP. REPLACED LAV SMOKE DETECTOR.SDR RRXA000181Fire Detector · contaminatedFIRE WARNING ON NR 4 ENGINE ON TAKEOFF (ALTITUDE 1500 FT AGL AT TAKEOFF POWER OF 1.89 EPR) ENGINE SHUT DOWN IN FLIGHT. CK'D FOR PNEUMATIC LEAKS, CK'D FIRE LOOPS, CLEANED ALL CONNECTORS. SUSPECT DEICING FLUID CONTAMINATED LOOP CONNECTIONS. ENG RUN CHECKS GOODSDR PLGA000128Fire Detector · malfunctionedALB - FLT 4755 - BOS-ROC, THE RIGHT TAIL PIPE HOT LIGHT ILLUMINATED IN CRUISE. THE CREW FOLLOWED THE CHECKLIST AND THE LIGHT REMAINED ON. IN CONTINUATION WITH THE CHECKLIST, THE CREW SHUTDOWN THE RIGHT ENGINE. DIVERTED INTO ALB AND THE AIRCRAFT LANDED WITHOSDR QXEA0000166Fire Detector · malfunctionedBOI- FIRE DETECTION LOOP B FAULT LIGHT ILLUMINATED ON NUMBER 1 ENGINE IN FLIGHT. REMOVED AND REPLACED B LOOP AND FIRE PROTECTION PANEL. OPERATIONAL CHECKS GOOD.SDR 00FDEA00024Warning System · activated00-14 - NR 3 ENGINE FIRE WARN LIGHT AND BELL CAME ON FOR AN INSTANT. PERF ADJ AND TEST PER MM 26-11-000-5, OPS CK NORM. RAN ENG TO T/O PWR 1.75 EPR FOR 15 MIN NO IND NOTED. OPS CK NORM. OK FOR SERVICE..SDR AU000033Wire · damaged(AUS) LEFT ENGINE FIRE DETECTION WIRE FAULTY.SDR AU000056Fire Detector · faulty(AUS) NR 1 ENGINE FIRE WARNING SYSTEM FAULTY.SDR SWAA000087Fire Detector · malfunctionedAIR TURNBACK/DECLARED EMERGENCY. APU FIRE LIGHT ILLUMINATED JUST AFTER TAKEOFF. PULLED FIRE HANDLE AND DISCHARGED FIRE BOTTLE. INSPECTED APU. NO INDICATION OF FIRE FOUND. DEFERRED APU.SDR ABXA000010Fire Detector · malfunctionedRIGHT ENGINE LOOP B LIGHT AND ANNUNCIATOR ILLUMINATED. COMPLIED WITH EMERGENCY PROCEDURES, DISCHARGED BOTH FIRE BOTTLES, DECLARED EMERGENCY AND SHUT DOWN RIGHT ENGINE. REPLACED FIRE DETECTOR ELEMENT ON LOOP B RIGHT ENGINE. OPS CHECKED GOOD.SDR 0000096305Fire Detector · malfunctionedDURING TAKEOFF, THE WHEEL WELL FIRE WARNING ACTIVATED. AIRCRAFT ABORTED TAKEOFF AND RETURNED TO THE GATE WITHOUT INCIDENT. REPLACED FIRE LOOPS M694, M693, M692, AND M691. OPERATIONAL CHECK GOOD..SDR 2000ZZZX436Connector · contaminatedON CLIMB-OUT, NR 1 ENGINE FIRE T-HANDLE ILLUMINATED AND FIRE TONE SOUNDED. ALL ENGINE INDICATIONS REMAINED NORMAL AND NO UNUSUAL SMELLS WERE EVIDENT. CLEANED CORROSION FROM PINS ON CONNECTORS OF NR 1 ENGINE FIRE DETECTOR CONTROL AMPLIFIER FIRE DETECTION. SYSSDR GXPA99010Wire · chafedRIGHT ENGINE FIRE LIGHT BLINKED ON INTERMITTENTLY IN ROUGH AIR. REPAIRED CHAFED WIRE ON UPPER ENGINE, FRAME. OPERATIONAL CHECK OK. (X)SDR 2000UALA00005Detector · shortedTHE AUXILIARY POWER UNIT FIRE BOTTLE DISCHARGED BY THE FLIGHT CREW . *S/D* THE SHORTED M717 DETECTOR CAUSED A FALSE FIRE INDICATION. REPLACED THE M717 LOOP AND THE AUXILIARY POWER UNIT FIRE BOTTLE. REPLACED THE M515 LOOP AS A PRECAUTION.SDR USAASB00007Bulb · faultyPHL - FLT 1223 - DURING DESCENT INTO PHL, BOTH MASTER CAUTION FIRE WARNING LIGHTS ILLUMINATED FOR APPROXIMATELY FIVE SECONDS. NO OTHER LIGHTS OR BELLS WERE NOTED. FLIGHT LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REMOVED AND REPLACED THE LIGHT BULBS IN THSDR 00FDEA00008Smoke Detector · malfunctioned00-8 NR 1 MAIN CARGO SMOKE WARN LIGHT CAME ON PRIOR TO DESCENT. PERF FIRE SMOKE AND FUMES AND MAIN DECK CARGO FIRE/SMOKE CKLIST. SYS CK GOOD. REMOVED AND REPLACED NR 1 SMOKE DET UNIT IAW MM 26-17-001-4. SYS CK NORM. OK FOR SERV.SDR CALA0000002Fire Detector · malfunctionedTHE APU FIRE WARNING LIGHT ILLUMINATED WHILETHE APU WAS NOT RUNNING, AFTER TAKEOFF FROM JAX. THE FIRE BOTTLE WAS DISCHARGED, BUT THE LIGHT DID NOT EXTINGUISH. THE AIRCRAFT WAS RETURNED TO JAX WHERE IT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND NO EVIDENCE OSDR UPS00831256Fire Detector · malfunctionedMX PREFLT, NR 2 ENG FIRE WARNING AND SHORT CIRCUIT TEST INOP. REMOVED AND REPLACED NR 2 FIRE DETECTOR CONTROL UNIT.SDR 00FDEA00004Fire Loop · malfunctioned00-4 - INTERMITTENT NR 2 ENG FIRE LIGHT AND BELL CAME ON AND WENT OUT. REPEAT WRITE-UP. SYS CK GOOD. REMOVED AND REPLACED LWR DUAL FIRE LOOP PER MM 26-12 (1739) NO HELP DUP PRO. DRIED BACKSHELL AND RESEALED SYS OPS CK GOOD IAW 26-11-000. RAN ENG FROM IDLESDR 20001229AP001Fire Warning · false indicationDFW - FLT 3646 - WHLE ON TAXI, FIRE INDICATION ON NR 1 ENGINE, ENGINE SHUT DOWN, FIRE HANDLE PULLED. AIRCRAFT RETURNED TO BLOCKS. PERFORMED INSPECTION OF NR 1 ENGINE AND AREA, NO INDICATION OF FIRE. REPLACED FIRE BOTTLE, OPS CHECK GOOD. (M)SDR GAIA0089Apu · inoperativeDURING CRUISE FROM MCI TO ELP, FLIGHT 1712, ENCOUNTERED AN APU FIRE WARNING LIGHT AND FIRE WARNING BELL. ALL EMERGENCY CHECKLISTS WERE COMPLIED WITH, ALONG WITH PULLING OF THE APU TIRE HANDLE AND DISCHARGING THE APU FIRE BOTTLE. SLOWED THE AIRCRAFT TO 270 KNSDR USAAD00003Connector · loosePHL-ATL - FLT 637 - AFTER TAKEOFF, THE RIGHT ENGINE 'B' FIRE LOOP INDICATED FAILURE AND THE FIRE INDICATION LIGHT WOULD NOT EXTINGUISH. THE AIRCRAFT RETURNED TO THE FIELD AND LANDED WITHOUT INCIDENT. MAINTENANCE SECURED THE ELECTRICAL CONNECTOR AT THE RIGHT
Back to JASC 2612