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 AALA20040794Sensor · malfunctionedORD - INFLIGHT T2252/01 ON FINAL RIGHT ENGINE FIRE INDICATION SHUT ENGINE DOWN AND FIRED BOTH BOTTLES. REPLACED BOTH ENGINE FIRE BOTTLES AND SQUIBS PER MM 26 21 01 4 FOR RIGHT HAND ENGINE AND REPLACED NR 1 TS5031 FIRE LOOP AND REPLACED NUMBER TWO CARD M684. SDR C2XA04BT083Fire Loop · defectiveNR 2 FIRE DET FAIL. REMOVED AND REPLACED ENG NR 2 FIRE LOOP, OPS CHECK GOOD.SDR COMA0460437Controller · malfunctionedFIRE FAIL CAUTION, LT ENGINE FIRE WARNING, IFSD LT ENGINE FOLLOWED BY RT ENGINE FIRE WARNING, AND APU FIRE WARNING. REPLACED THE FIREX CONTROLLER.SDR CA040811002Control Unit · failed(CAN) FLT DIVERTED, EMERGENCY DECLARED. ON CLIMBOUT RECEIVED NUMEROUS FIRE FAIL MSGS., CAUTION MSG, THEY ALL DISAPPEARED. WE THEN RECEIVED A LH ENG FIRE WARNING AND WE SHUT DOWN NR 1 ENGINE. ON APPROACH WE RECEIVED A RH ENGINE FIRE WARNING MSG, ON LANDING WE RSDR UPS04442803Fire Warning · false indicationFIRE INDICATION ON NR 3 ENGINE. EXECUTED FIRE IN FLIGHT SHUTDOWN. BOTH FIRE BOTTLE DISCHARGED. INITIALLY OBTAINED FIRE DETECTION LIGHT ON FWD PANEL COUPLED W/FAULT LIGHT ON DET PANEL. ENG FIRE TEMP SENSOR IN ORANGE, INCREASING EMERGENCY RED FIRE HANDLE ILLSDR QXEA200400571Fire Loop · malfunctionedDURING APPROACH THE CHECK FIRE DETECTOR MASTER WARNING ILLUMINATED ALONG WITH THE MASTER WARNING LIGHT. MAINTENANCE INSPECTED THE AIRCRAFT FIRE LOOPS 1 AND 2, THE 1 AND 2 ENGINE DETECTORS, FORWARD BAGGAGE, AND APU FIRE DETECTOR SYSTEMS. ALL SYSTEMS CHECKED GOOSDR CX7A194J0443Fire Detector · inoperativeAT 4000 FT, WE RECEIVED A MOMENTARY FIRE DET FAIL LT ON THE RT ENG. ABOUT 2 SEC AFTER IT WENT OUT WE RECEIVED A MOMENTARY RT ENG FIRE WARNING. PERFORMED ENG CHECK LIST AND LANDED (RT FIRE BOTTLE WAS DISCHARGED). ADJUSTED FIRE LOOPS AND CHANGED OUR FIRE DETESDR 2004F00372Fire Detector · dirtyIN FLIGHT, HAD FLOWN APPROXIMATELY 12 MINUTES OUTBOUND, THEN HEARD GONG AND HAD ENGINE FIRE LIGHT INTERMITTENTLY. TURNED AROUND TO RETURN TO ICY AND LIGHT WENT OUT. ON FINAL TO ICY, LIGHT CAME BACK ON STEADY FOR 3 TO 5 SECONDS THEN WAS INTERMITTENT. MAINTENSDR HAEA200400160Fire Loop · false indicationENGINE NR 1 FIRE DETECTION WARNING ILLUMINATES AT EXHAUST TEMPS OF EXCEEDING 600 DEGREES CELSIUS IN CLIMB-OUT OR IN WARM AMBIENT TEMPS. REPLACED UPPER COWLING SENSOR. OPS CHECK GOOD.SDR 04FDEA02193Smoke Detector · inoperativeAFTER T/O AFT AND BULK SMOKE ECAM ALERT, AIRBORNE ABORT BACK TO MEM, FOLLOWED ECAM PROCEDURES. ENT BY: 029496 RPT BY: 118583 MEL 26-16-01: FWD, AFT AND BULK) ALL SMOKE DETECTION SYSTEMS INOP. NO CARGO IS TO BE CARRIED WITH AFFECTED LOWER DECK COMPARTMENTS. SDR DXTA200400345Fire Detector · malfunctionedLT ENGINE FIRE LIGHT CAME ON DURING TAXI, BOTH FIRE BOTTLES BLOWN. NO INDICATION ON ENG FIRE UPON EVACUATION. INSPECTED ENGINE WITH NO EVIDENCE OF FIRE, REMOVED AND REPLACED BOTH FIRE BOTTLES IAW MM CHAPTER 26-21-01, RAN ENGINE FOR 20 MINUTES AT VARIOUS POWESDR VNAA0407005Fire Loop · failedTHE CREW REPORTED THAT THE LEFT HAND ENGINE FIRE LOOP-A WAS INOP. MAINTENANCE CONTROL DEFERRED THE LEFT HAND FIRE LOOP-A WITH THE CREW PER MEL 26-11-01 CODE-C. THE AIRCRAFT WAS THEN RELEASED FOR SERVICE.SDR AWXA200400802Warning Light · false indicationFALSE FIRE WARNING ON CLIMB OUT, AFTER SELECTING FLAPS UP RECEIVED FWD CARGO FIRE LIGHT AND FIRE BELL, DISCHARGED NR 1 CARGO FIRE BOTTLE AND LIGHT EXTINGUISHED, DECLARED EMERGENCY AND LANDED WITHOUT FURTHER EVENT. MAINT MET AC AND PERFORMED A MAINT BITE TEST SDR VNAA0407003Fire Loop · failedTHE CREW REPORTED RECEIVING A LEFT HAND JET OVERHEAT FAIL INTERMITTENTLY. MAINTENANCE INSPECTED AND FOUND THAT WITH THE LOOP-B SELECTED, THE INDICATION EXTINGUISHES AND WITH LOOP-A, SELECTED, THE INDICATION STAYS ON. MAINTENANCE CONTROL THEN DEFERRED LOOP-A SDR 2004F00320Fire Loop · looseENGINE FIRE LIGHT AND HORN CAME ON IN LEVEL FLIGHT. INDICATIONS CEASED ON APPROACH TO LANDING. ALL OTHR INDICATIONS NORMAL. PILOT DECLARED AN EMERGENCY. AIRCAFT LANDED WITHOUT INCIDENT. PILOT NOTED THAT NO FIRE EXISTED AND IT WAS A FALSE INDICATION. MECHSDR GTIA040669Fire Loop · malfunctionedRT ENGINE B-LOOP ILLUMINATED. REMOVED AND REPLACED RIGHT ENGINE FIRE LOOP. (M)SDR XNOA1192Battery · malfunctionedMAIN CARGO FIRE ALARM ILLUMINATED DURING DESCENT, VISUAL CHECK OKAY. LIGHT EXTINGUISHED SHORTLY AFTER. REMOVED AND REPLACED 2 EACH MAIN DECK SDU BATTERIES. SDU CHECKS GOOD IAW SECURE-A-PLANE MM.SDR DHL2004805007Warning Light · illuminatedWHILE EN ROUTE NR 1 ENGINE FIRE DETECTION SYSTEM ACTIVATED.SDR UPS04242757Fire Detector · false indicationINSPECTION TYPE:N/A, ATB - RETURN TO PHX DUE TO WHEEL WELL LIGHT ILLUMINATED IN FLIGHT. INSPECTED LT AND RT WHEEL WELL FIRE LOOPS, NO DAMAGE NOTED. COCKPIT WHEEL WELL FIRE SYSTEM TEST OK PER 727 MM 26-01-00.SDR GUU2004F00026Fire Loop · brokenAFTER TAKEOFF, FIRE LOOP ENUNCIATOR AND RT T-HANDLE ILLUMINATED. THE RT ENGINE WAS SHUT DOWN AND THE FIRE EXTINGUISHER WAS FIRED. DECLARED AN EMERGENCY RETURN TO FLL. INSPECTED RT ENGINE. NO EVIDENCE OF FIRE OR FLUID LEAKS FOUND. FORWARD FIRE LOOP BROKEN SDR SWIA200413566Fire Loop · false indicationLEFT ENGINE WHEEL WELL FIRE DETECTION LIGHT INDICATION ON. REMOVED AND REPLACED LEFT HAND ENGINE FIRE DETECTION LOOP IAW MM 26-11-01. OPERATIONAL CHECK GOOD. P/N: 3601-75-450/160C-5-817, S/N OFF: 7071.SDR DHL2004363006Fire Loop · will not testENG NR 2 FIRE LOOP "B" DOES NOT TEST. DEFERRED IAW MEL 26-12-01-1, ASSIGNED CONTROL NR 17142, PLACARD INSTALLED, SP/CW.SDR DHL2004742004Element · out of adjustNR 3 FIRE PROTECTION SYSTEM GROUND DETECTOR CIRCUIT ANNUNCIATOR PULSES FAINTLY. ADJUSTED NR 3 FIRE PROTECTION SENSING ELEMENTS PER MM 26-11-01, OP'S CHECK NORMAL.SDR DHL2004784003Fire Loop · groundedNR 3 ENGINE FIRE DETECTOR CIRCUIT GROUND LIGHT IS ILLUMINATED. REPOSITIONED NR 3 ENGINE GROUND FAULT FIRE DETECTOR LOOP. CLOSED AND RESECURRED NR 3 ENGINE COWL. TESTED ENGINE FIRE DETECTION IAW B727 M/M 26-11-001. NO DEFECTS NOTED.SDR CX7A194J0437Fire Loop · brokenLEFT BLEED AIR LEAK. RAN CHECKLIST, LIGHT STAYED ON. SHUT DOWN LEFT ENGINE, DIVERTED TO SBN.SDR GTIA040645Control Panel · intermittentFLL - FOUND CARGO FIRE AND CARGO DET LOOP LIGHT ON IN FLIGHT INTERMITTENTLY. REMOVED AND REPLACED DETECTION CONTROL PANEL. SYSTEM OPS CHECK GOOD. (M)SDR DHL2004807011Warning Light · illuminatedDURING CRUISE FLIGHT, LOWER CARGO FIRE "MX" LIGHT ILLUMINATED "SYS OK" LIGHT REMAINED ILLUMINATED. NO DEFECT NOTED, PERFORMED SYSTEM OPS CHECK IAW MM SUPP 26-15-00, OK FOR SERVICE.SDR DHL2004367006Fire Loop · inoperativeDURING PRE-DEPARTURE CHECK FOUND ENGINE NR 1 LOOP-A INOP. DEFERRED PER MEL 26-12-01-1, DMI 17031. S/P COMPLIED WITH.SDR 180041Clamp · brokenCAPT REPORTED LT T HANDLE ILLUMINATED, SECURED ENGINE, BLEW FIRE BOTTLE, T HANDLE STILL ILLUMINATED, CONDUCTED A HIGH SPEED DECENT, T HANDLE EXTINGUISHED AIRCRAFT DIVERTED. FOUND BROKEN FIRE LOOP CLAMP BELOW EXHAUST STACK, REPOSITIONED CLAMP, OPS CHECKED GOODSDR CA040625002Fire Loop · malfunctioned(CAN) DURING FLIGHT, NR 3 ENGINE FIRE WARNING INDICATION WAS ACTIVATED. BELL WAS INTERMITTENT BUT BECAME A LITTLE MORE STEADY. EMERGENCY PROCEDURES WERE INITIATED AND NR 3 ENGINE WAS SHUTDOWN. FIRE HANDLE WAS PULLED BUT NOT TO RELEASE EXTINGUISHING AGENT. SDR SWIA200413517Detector · malfunctionedAPU INOP FIRE DETECTION LIGHT ILLUMINATED ON TAXI. REMOVED AND REPLACED APU FIRE/OVERHEAT DETECTOR. OPS CHECK GOOD REF 26-12-01. P/N: 3601-90-4501180C, S/N OFF: 80388.SDR DHL2004764006Fire Detector · malfunctionedLOWER CARGO FIRE DETECTOR DOES NOT TEST PROPERLY. RED ANNUNCIATOR ON S/O PANEL, NOR RED ANNUNCIATOR ON FWD GLARESHIELD DOES NOT ILLUMINATE. RESET CARGO FIRE DETECTOR, SYS OPS GOOD IAW MM 26-10-0.SDR DHL2004760006Warning Light · false activationON PREFLIGHT, FOUND LOWER AFT CARGO FIRE LIGHT ILLUMINATED. TRANSFERED TO DMI NR 17008 PER ASTAR MEL 26-19 CAT C SEE SP 26-19. PLACARD INSTALLED EMP NR 35944.SDR 071152Warning Light · illuminatedAPPROXIMATELY 1430 (UTC), FLT 7926 IAD-ABE. THE AIRCRAFT WAS EN ROUTE TO ABE WHEN THE CREW OBSERVED THE RIGHT FIRE DETECT FAIL INDICATION, FOLLOWED BY THE RIGHT FIRE WARNING. CREW FOLLOWED QRH PROCEDURES. BOTH EXTINGUISHERS WERE USED. THE ENGINE WAS SHUTDOSDR 04028Fire Loop · malfunctionedNR 3 ENG FIRE IND IN FIRE SWITCH AND "B" LOOP AT 9.5 DURING CRUISE. "A" LOOP INOP. ENG SHUTDOWN AND BOTH FIRE BOTTLES DISCHARGED AND FIRELIGHT REMAINED ON. CONDITIONS BEFORE SHUTDOWN, OIL PRESSURE 47-PSI OIL TEMP 88. NO IGNITION OR ANTI-ICE. AFTER SHUTDOWSDR GTIA040578Connector · shortedORD - FLT 1103 - RIGHT ENGINE LOOP B AND FIRE DETECTOR LOOP CAUTION LIGHTS CAME ON WITH NO OTHER ABNORMALITIES. LOOP A SELECTED AND LOOP A TESTED GOOD. FOUND CONNECTOR P1-863 SHORTED REMOVED AND REPLACED CONNECTOR P1-863 ON RIGHT ENGINE FIRE LOOP 'B'. SYSTESDR REX2004F00000Warning Light · illuminatedFALSE CARGO SMOKE WARNING ON FINAL. EMERGENCY DECLARED QRH FOLLOWED EXTINGUISHERS DISCHARGED, UNEVENTFUL LANDING. CARGO FIRE EXTINGUISHERS REPLACED, OPERATIONAL TEST PERFORMED IAW AMM OF CARGO DETECTION SYSTEM WITH NO DEFECTS NOTED.SDR 173041Clamp · looseRIGHT FIRE HANDLE FLICKERING INTERMITTENTLY IN FLIGHT. REMOVED TOP AND SIDE COWLS, INSPECTED FIRE LOOP ASSY AND CLAMPS REPOSITIONED AND SECURED LOOP ASSY PER MM 26-10-01, PERFORMED LAMP TEST, OP CHECKED GOOD.SDR GTIA040574Connector · dirtyRIGHT LOOP B LIGHT CAME ON DURING FLIGHT. PERFORMED QRH PROCEURE, LOOP A OK. T/S CLEANED CONNECTORS ON B LOOP ENGINE CONNECTORS UNABLE TO FIND CONCLUSIVE FAULT, OPS CHECK OK. (M)SDR 0401001225Fire Loop · malfunctionedON CLIMBOUT AT 31,000 FT, RECEIVED NR 2 ENGINE FIRE WARNING INDICATION. NR 2 ENGINE B-LOOP WAS PUT ON MEL. SHUT DOWN NR 2 ENGINE IAW COM PROCEDURE. DUMPED 90,000 LBS OF FUEL AND RETURNED TO NRT FOR AN UNEVENTFUL LANDING. WORK IN PROGRESS-SUPPLEMENTAL INFORMATSDR CA040621003Fire Detector · shortedDURING APPROACH FOR LANDING, THE RT ENGINE FIRE WARNING ANNUNCIATOR ACTIVATED. THE PILOT DEPLOYED THE ENGINE FIRE BOTTLE, SECURED THE ENGINE AND DECLARED AN EMERGENCY. THE LANDING CONTINUED UNEVENTFUL. MX INSPECTED THE ENGINE AND FOUND NO EVIDENCE OF FIRE. THESDR DLM90040565Fire Loop · malfunctionedPASSING 3000 FT RT ENGINE FIRE DETECTOR FAULT MESSAGE ILLUM IT STAYED ON FOR APPROX 1 MIN AND THEN WENT OUT. FIRE DET FAULT MESSAGE CAME ON WITH RT ENG B-LOOP LIGHT. LIGHT INTERMITTENT CAME ON AND OFF WITH WITH -B- LOOP. PERFORM FAULT TEST PER T/S MANUAL. SDR DHL2004760005Fire Detector · inoperativeFWD FIRE DETECTOR WON'T ILLUMINATE. C/F TO DMI LOG IAW MEL 26-19 ASSIGNED 16934 PLACARD INSTALLED. CYCLED LOWER CARGO DETECTOR CIRCUIT BREAKERS IAW MM 26-16-01, SYSTEM OPS CKS NORMAL. TEST FUNCTIONS CHECK GOOD THIS CLEARS DMI 16934, PLACARD REMOVED. NO PARSDR DHL2004362005Controller · malfunctionedLEFT WING MANIFOLD FAULT DETECTOR LOOP B INOP IN TEST. FOUND EITHER LOOP FIN NR 145HF OR FIN NR 147 HAS ONLY 2M OHMS TO GROUND. ON ORDER REQ NR 300109474. DMI NR 16915 STILL OPEN. REF DMI 16915, LT WING MANIFOLD FAULT DETECTOR LOOP B INOP IN TEST. C/W S/PSDR 04FDEA01706Control Unit · failedDISCHARGED BOTH LOWER CARGO COMPT FIRE BOTTLES, INDICATION OF FWD LOWER CARGO FIRE. AFTER CHECKING COMPARTMENT AND WHILE BEING TOWED HAD ANOTHER ACTIVATION OF LOWER CARGO FIRE WARNING. REMOVED AND REPLACED LWR FWD CARGO COMPT FIRE SUPP/SMOKE DET CONTROL ELECSDR DHL2004748003Fire Loop · out of positionNR 1 FIRE DETECTOR CIRCUIT GROUND LIGHT ON C/B PANEL ILLUMINATED IN FLIGHT. DOES NOT ILLUMINATE ON GROUND. DEFERRED NR 1 FIRE WARNING GROUND FAULT DETECTOR SYS. PER MEL 26-9-1 DMI 16886 PLACARD INSTALLED. REPOSITIONED NR 1 ENG FIRE LOOP PER DHL B727 MM 26-SDR QXEA200400431Fire Loop · malfunctionedSEA - THERE WAS A LOOP -A- FAULT LIGHT ILLUMINATED ON NR 1 ENGINE FIRE DETECTION SYSTEM. FOUND NR 1 ENGINE FIRE LOOP -A- CIRCUIT BREAKER NOT SET. RESET CIRCUIT BREAKER. C/W FIRE/OVERHEAT DETECTION SYSTEM ADJUST/TEST. OPERATIONAL CHECK GOOD. AIRCRAFT RETURSDR 04FDEA01694Fire Loop · damagedNR 2 MANIFOLD FAIL LIGHT ILLUMINATED DURING CLIMB, CHECKLIST COMPLETE, LIGHT WENT OUT. DUMPED FUEL AND RETURNED TO MEM. LANDED UNEVENTFULLY. *S/D* PERFORMED DECAY CHECK OF NR 2 SYSTEM REF DC10-30 JRH. DECAY TEST FAILED FOUND THE CENTER CARGO JET PUMP SHUTSDR 04FDEA01696Control Unit · malfunctionedFORWARD LOWER CARGO COMPARTMENT FIRE INDICATION ON TAXI OUT. NO ACTUAL FIRE REPORTED BY FIRE DEPARTMENT AFTER FIRE BOTTLES DISCHARGED INTO FWD LOWER CARGO COMPARTMENT. REMOVED AND REPLACED BOTH NR 1 AND NR 2 FIRE BOTTLES AND THE CARTRIDGES PER MM 26-17-014-SDR ARWA20040601Amplifier · malfunctionedDURING TAXI, NR 2 ENGINE FIRE WARNING INTERMITENTLY ILLUMINATED FIRE WARNING TEST INOPERATIVE, SHUT DOWN ENGINE; RETURNED TO RAMP. NO FIRE NOTED. CHECK FIRE WARNING SYSTEM AT RUNUP CONDITION. CHECK WIRING FOR CONDITION, ELEMENTS FOR CONDITION AT NR 2 ENGIN
Back to JASC 2612