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 EIAA2011237Fire Warning · false activationDURING DESCENT AT APPROX 10,000FT APU FIRE BELL SOUNDED BRIEFLY AND "A" LOOP LIGHT ILLUMINATED. CLEANED C/P FIRE DET SYS, PERFORMED OPS TEST PER MM 26-15-00. OPERATION NORMAL, COULD NOT DUPLICATE.SDR VGCA20111007Fire Loop · shortedRT ZONE, 3 FIRE WARNING INDICATION DUE TO A FIRE LOOP SHORTAGE.SDR DXTA2011100404742Fire Loop · chafedAPPROX 30 MIN FROM DESTINATION, NOTED LT ENGINE FIRE WARNING LIGHT DIMLY ILLUMINATED. ALL ENGINE PARAMETERS WERE NORMAL, REDUCING THRUST LEVER ON AFFECTED SIDE, NO CHANGE. PERFORMED INSPECTION OF FIRE LOOP ZONE 1. FOUND LOOP CHAFING ON GEARBOX, NO DAMAGE OR SDR EIAA2011234Circuit Card · not seatedAPU FIRE LOOP A BEGAN TO FLICKER DURING DESCENT. RESEATED A5 CIRCUIT GOOD AS PER MM 26-11-03.SDR CA111012009Fire Detector · inoperative(CAN) RED APU FIRE CAS POSTED INFLIGHT AT FL180. CREW WAS FLYING WHEN THEY REPORTED THE RED *APU FIRE* CAS MESSAGE HAD POSTED, CLIMBING OUT AT APPROX FL180. THE CREW FOLLOWED THEIR CHECKLIST AND BLEW THE NR 2 FIRE BOTTLE. THE RED *APU FIRE* CAS MESSAGE THEN ESDR J7SA20111002001Fire Loop · false indicationAIR DIVERSION, RED APU FIRE CAS POSTED IN FLIGHT AT FL180. REPLACED BOTH FORWARD APU FIRE LOOPS AND BOTH AFT SENSE ELEMENTS. OPS CHECKED GOOD.SDR C2XA20111002152Switch · faultyACFT WAS IN FOR A SERVICE ROUTINE AND ON THE MORNING DEPARTURE CLIMBOUT THE CREW GOT A AURA WARNING OF A FIRE. ACFT RETURNED TO DEPARTURE WHERE MX FOUND THE NR1 ENG FIRE SWITCH WOULD NOT LOCK DOWN INT DOWN POSITION. MX R & R THE ENG FIRE SWITCH IAW MM 31-00-SDR W6J2011F00000Unknown · faultyLT ENG "FIRE LOOP A", CAS INDICATION AFTER TAKEOFF (1,000 AGL) FOR 4 MINUTE DURATION. NO OTHER INDICATIONS DURING OR AFTER CAS MESSAGE EXTINGUISHED. THIS IS AN INDICATION OF A FIRE LOOP A FAILURE, NOT AN ENGINE FIRE. AN EXTENSIVE INSP WAS PERFORMED INCLUDINSDR EIAA2011230Circuit Card · faultedNUMBER 1 ENGINE FIRE DETECTOR A LOOP FAULTED. RESET FIRE DETECTOR CARD PER AMM 26-11-00. OPS CHECKED NORMAL.SDR 3PRA2011092400001Fire Loop · false activationNR 2 ENGINE FIRE LIGHT ILLUMINATED DURING FLIGHT. MX FOUND THE AFT FIRE LOOP WIRE TO BE DEFECTIVE. REPLACED WITH NEW ELEMENT.SDR UALA2011092705209Fire Loop · shortedFIRE HANDLE WAS PULLED BY FLIGHT CREW DUE TO APU AUTO SHUT DOWN. BEFORE DEPARTURE APU AUTO SHUT DOWN, APU CONSIDERED INOPERATIVE. CREW PULLED HANDLE AND DISCHARGED FIRE EXTINGUISHER. REPLACED APU FIRE EXTINGUISHING BOTTLE AND SQUIB PER MM. BOTTLE PRESSURESDR FDEA201109224071Fire Warning · false activationON A G/A, FIRE WARNING LT, EICAS MAIN CARGO FIRE LIGHT CAME ON FOR LESS THAN 15 SECONDS, LANDED, NO SIGNS OF FIRE. PERFORMED BITE TEST IAW FIM 26-16-30-101, NO FAULTS DETECTED. ACFT OK FOR SERVICE.SDR C2XA11IA225Control Module · malfunctionedSLW - FLIGHT 1760, THE CREW REPORTED AN ENGINE 1 FIRE DETECTOR FAIL ON TAKEOFF ROLL AT 50KTS. THE CREW ABORTED TAKEOFF AND RETURNED TO THE GATE WHERE THE AIRCRAFT WAS INSPECTED AND APPROVED FOR A FERRY FLIGHT TO IAH. THE AIRCRAFT LANDED AT IAH WHERE MAINTENASDR UALA2011092005092Pin · severedFIRE, L ENG OVHT, FIRE & OVHT LIGHTS FAILED TO ILLUMINATE DURING ENG-APU-CARGO FIRE-OVHT TEST. APPROPRIATE EICAS MSG WAS DISPLAYED. CREW COMMENTS: ENG OVHT LT NO TEST. REPLACED SEVERED PIN AT NR 2 LOCATION ON L ENG OVERHEAT LIGHT ON ENG FIRE CONTROL PANEL.SDR EIAA2011227Warning System · false activationDURING DESCENT NR 3-A NACELLE TEMP INDICATOR AT 5.5 WITH FIRE DETECTION LIGHT ON FORWARD ANNUNCIATOR PANEL ILLUMINATED. TESTED NR 3-A NACELLE TEMP INDICATION IAW AMM 26-11-00. NO DEFECTS NOTED.SDR MYWA110097Fire Warning · malfunctionedETOPS SIGNIFICANT SYSTEM: CARGO FIRE TEST FAILED AFT CARGO FIRE LIGHT DOES NOT COME ON DETECTOR FAULT LIGHT COMES ON DET SELECT SWITCH AT "B". PERFORMED FIM 26-16 TASK 804, NO DEFECTS NOTED, SYSTEM OPS CHECK NORMAL.SDR SIMA201125808Unknown · malfunctionedDURING PREFLIGHT INSPECTION FOUND THE BAGGAGE EXTINGUISHER LIGHT DOES NOT ILLUMINATE DURING FIRE TEST. THE LIGHT DID NOT ILLUMINATE AND STAYED ON AFTER TEST. THE AIRCRAFT WAS REMOVED FROM SERVICE. COMPLIED WITH OPERATIONAL CHECK OF FIRE DETECTION SYSTEM IAWSDR C2XA11RI151Fire Warning · false activationIN FLIGHT CREW REPORTED E1 FIRE DETECT FAIL MESSAGE ON EICAS. IAD MX PERFORMED OPERATIONAL CHECK OF E1 FIRE DETECTION SYSTEM SUCCESSFULLY IAW EMB-145 AMM 26-10-00. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR NOCA08711Warning System · malfunctionedFIRE BELL DID NOT RING DURING TEST WHEEL WELL AND FIRE/OVHT TEST ENG/APU, CARGO OTHER INDICATIONS NORMAL. RESET RIGHT MASTER CAUTION RESET SWITCH OPS CHECK OK PER MM 26-10-00.SDR 2011F00200Fire Loop · inoperativeRIGHT ENGINE FIRE WARNING LIGHT FLASHES ON AND OFF IN FLIGHT AND ON THE GROUND, R & R FIRE LOOP, OPS CHECKED GOOD.SDR TRBA201124904Fire Warning · false activationAFTER STARTING NR 2 ENG, GOT NAC OVERHEAT AND ENG FIRE WARNING. RAMP HAD 20 KNOT TAIL WINDS ON ACFT. PERFORMED GROUND ENG RUNS INTO HEAD WIND IAW JIC MM 72-00-00. OPS CHECKED GOOD AT THIS TIME.SDR SIMA201124911Fire Loop · faultyFOR FLIGHT 3752 THE CREW REPORTED, RECEIVED A FIRE SYSTEM FAULT STATUS MESSAGE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE FIRE LOOPS A, AND B UNDER AFT CORE COWL IAW CRJ AMM 26-11-11, ALSO REMOVED AND REPLACED THE UPPER AND LOWER FIRE LSDR SIMA201124909Unknown · malfunctionedFOR FLIGHT 2803 THE CREW REPORTED THE APU FIRE DETECTOR LIGHT WOULD NOT TEST. THE AIRCRAFT WAS REMOVED FROM SERVICE. PERFORMED OPERATIONAL CHECK OF FIRE DETECTION SYSTEM IAW ERJ AMM 26-10-00. THE OPERATIONAL CHECK WAS GOOD, NO PARTS REMOVED OR REPLACED. TSDR IPXA11M69010Fire Loop · inoperativeDURING PDC FOUND NR2 ENG FIRE LOOP B FAULT SHOWN ON MAINT PAGE. 461418 ASSIGNED FOUND PYLON NR2 ENG "B" FAULTING. R & R NR 2 ENG PYLON FIRE LOOP (B) IAW MM SUBASK 26 11 03 020 012 TO PAGE 22, STEP E. COMPLETED INSTALLATION IN REF TO MM 26 11 05 4. OPS CHSDR IPXA1M69010Fire Loop · faultedDURING PDC FOUND NR 2 ENG FIRE LOOP B FAULT SHOWN ON MAINT PAGE. CFDS FDCU-2 FAULT REV SHOWS PYLON FIRE DET ASSY B FAULT. REMOVED POWER FROM FDCU-2. NO HELP. ITEM DEFERRED IAW MEL 26-11-1. DMP ACCOMPLISHED PLACARD INSTALLED.SDR GLBA20110831HFire Warning · illuminatedPILOT REPORTED THAT WHILE CLIMBING THE MASTER WARNING AND NR 2 T-HANDLE ILLUMINATED, EMERGENCY DECLARED, NR 2 ENGINE WAS SHUTDOWN, LANDED WITHOUT INCIDENT. MX REPLACED PCB E173 IAW MI 24-01 PN: 129-364037-1 SN: 657-I-86 AND FWD & AFT FIRELOOPS IAW 26-10-01 PNSDR YENA20110829329Fire Loop · out of positionFLT 1799 FLL-SDQ, 2ND AIR RETURN TO FLL- BLEED LEAK AT 31,000 QRH PERFORMED. FOUND LOOPS 3 CHANNEL 1 AND 2 ZONE 16 ROUTED AND TOUCHING FIRE RETARDANT TUBING, RE-ROUTED FIRE LOOP 3 ENG NR 1 CHANNEL 1 AND 2 TO CORRECT CONFIGURATION IAW AMM 36-22-01. LOOP 3 NOTSDR HALA2011082900393Connector · dirtyETOPS SIGNIFICANT SYS - ON STATUS PAGE LT ENG LOOP LIGHT 2 CAME ON FOR 10 MIN THEN WENT OUT, NO OTHER INDICATION. CLEANED FIRE LOOP CONNECTIONS ON LT ENG. PERFORMED FIRE LOOP TEST OPS CK NORMAL. RAN NR 1 ENG, OPS NORMAL, OK FOR SERVICE.SDR NSVA2011180Fire Loop · saturatedAT SPEED OF 90 KTS PILOT REPORTED, TAIL PIPE HOT LIGHT ILLUMINATED. CREW ABORTED THE TAKEOFF AND RETURNED TO GATE. NO EMERGENCY WAS DECLARED. INSPECTED AND FOUND INTERNAL TAILPIPE SOAKED. PERFORMED A/C RUNS AND INSPECTED THE FIRE LOOP SYSTEM. OPS CHECKED SDR UALA2011082404536Unknown · malfunctionedRIGHT ENG FIRE LOOP 1 INOPERATIVE. FIRE TEST SHOWS PASS BUT UNABLE TO CLEAR STATUS MSG. TO DF2611C APPLIED. NO MSG ARRIVAL IAD. ACP'D SYSTEM TEST. TEST PASS, MSG CLEARED.SDR ASAA11510295Fire Loop · defectiveDURING TAXI OUT WITH APU TURNED OFF. THE "APU DET INOP" & "OVHT/DET" MASTER CAUTION LIGHTS ILLUMINATED. PERFORMED APU FIRE DETECTION CONTROL MODULE BITE PER FIM 26 10 TASK 801 FAULTED APU TAIL PIPE FIRE DETECTION LOOP. REPLACED APU TAIL PIPE FIRE DETECTION SDR HALA2011082400384Warning Light · inoperativeOPEN - AFT LAV FIRE WARNING LIGHT WILL NOT ILLUMINATE WHEN TESTED. (LAV LOCKED-OUT). OK TO CONTINUE IAW MEL 26-14-01.SDR CA110824002Fire Loop · failed(CAN) PASSING FL150, MSG WARNING "L BLEED DUCT ". THE 2 ENG BLEEDS CLOSED AUTOMATICALLY AND PRESSURIZATION FAILURE IN CONSEQUENCE. QRH APPLIED AND DESCENT INITIATED TO FL100. UNPRESSURIZED FLIGHT BACK TO AIRPORT OF DEPARTURE. THE QAR/MDC WERE DOWNLOADED ONSDR AALA20110823TUL16Fire Detector · faultyLAS - CREW REPORTED RIGHT ENGINE OVERHEAT LIGHT ILLUMINATED DURING CLIMBOUT. EMERGENCY DECLARED FLIGHT RETURNED LAS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LOWER FAN FIRE WARNING AND CORE LEFT AND RIGHT FIRE WARNING / DETECTORS. SYSDR UIEA2011082300458Fire Warning · false indicationPRIOR TO LANDING, HAD A FALSE MAIN DECK FIRE WARNING INDICATION. WARNING TERMINATED AFTER 30 SECONDS. PERFORMED FIRE DETECTION SYS TEST IAW MM 26-14-00. PASSED WITH NO DEFECTS FOUND.SDR HALA2011082000380Fire Warning · false activationETOPS SIGNIFICANT SYS - ECAS MESSAGE "LEFT ENGINE FIRE LOOP 2" ILLUMINATED THEN EXTINGUISED. T/S IAW FIM 26-11-00, FIG 104. INSPECTED LOOPS, NO PROBLEMS NOTED. PERFORMED BITE PROCEDURES WITH NO FAULTS. PERFORMED RESISTANCE CHECK, FOUND OK. INSPECTED ENGINESDR ASAA1150250Unknown · malfunctionedNR 1 ENG OVERHEAT & FIRE DETECTION "B" LOOP DOES NOT TEST & HAS A FAULT LIGHT. CONFIRMED FAULT NR 1 ENGINE B-LOOP FIRE DETECTOR INOP A LOOP OK. M279 ENG/APU FIRE/OVHT MODULE SHOWED L CORE FAULT WHEN A/C FIRST ARRIVED. LATER BITE SHOWED R CORE FAULT & INTERMSDR ASAA1150228Unknown · malfunctionedNR 1 ENGINE FIRE LIGHT FAULT (B LOOP) ON TEST. ACCOMPLISHED ENG FIRE DETECTION TEST OPS NML. BITE CHECK OF FIRE DETECTION CONTROL MODULE SHOWS NO FAULTS. GVI OF NR 1 ENG FIRE LOOP AND HARNESS GOOD. NO DISCREPANCIES NOTED. ALL SYS OPS NML. GROUND VERIFICASDR UALA2011081104209Switch · inoperativeAFT CARGO FIRE WARNING LIGHT ON PEDESTAL INOPERATIVE. REPLACED SWITCH ASSY, GROUND CHECKED OKAY.SDR GLBA20110810JDetector · inoperativePILOT REPORTED THAT THE BAGGAGE SMOKE-FIRE EXTINGUISHER UNIT WON'T TEST ON NR 2. MX REPLACED THE NR 2 DETECTOR, PN: 473597-13 SN: 1504, IAW EMM 26-14-01, OPS CK GOOD.SDR QMLA2011080911083Switch · faultyFIRE DETECTION LIGHT CAME ON IN FLIGHT. PROBLEM FIXED BY REPLACING FIRE DETECTION SWITCH AND FIX WIRES ON LIGHT.SDR IPXA1568428Fire Detector · false activationRT ENGINE FIRE IN FLT QRH PROCEDURES FOLLOWED, ENG SHUTDOWN. AC OOS. FIRE BOTTLES 1 & 2 DISCHARGED. R & R ENGINE FIRE BOTTLE NR 1 AND NR 2 IAW AMM 26-21-01-4. TESTS SATISFACTORY. INSPECTED RT ENGINE FOR SIGNS OF FIRE OR OVERHEAT AND NO DAMAGE FOUND. ACCOMSDR S9BA20110007Sensor · contaminatedRIGHT FIRE PULL HANDLE ILLUMINATED AND FIRE BELL SOUNDED IN FLIGHT. OPENED COWLING AND DRAINED WATER. INSPECTED FIRE WARNING SENSORS, GROUND RAN, SATISFACTORY. NO DEFECTS NOTED.SDR UALA2011080103983Fire Detector · no testFIRE WARNING WILL NOT TEST PROPERLY. CLEANED CAPT FIRE LIGHT CONTACT, CHECKED NORMAL.SDR EIAA2011097Warning System · false activationNR 3 ENGINE A LOOP FIRE DETECTION SYSTEM FAULT LIGHT ILLUMINATED, GAUGE NEEDLE FLUCTUATING. XFRD TO DMI 182 AS PER MEL 26-1 CAT C DUE 8/11/11. INSTALLED PLACARD. RESEATED AND SHOOK DOWN LOOP SENSOR AND CHECKED FOR CHAFING WIRES. NO FAULT FOUND. OPS CHECK SDR UALA2011080103939Guard · missingSECONDARY PLASTIC GUARD MISSING ON CARGO FIRE BOTTLE DISCH SWITCHES. PER EVA-81163 THIS IS AN ACCEPTABLE CONDITION FOR A PERIOD OF 10 DAYS. AS A RESULT, CARGO COMPARTMENT FIRE EXTINGUISHER 2 IS INOP PER MEL 2623A.SDR EIAA2011096Circuit Card · defectiveNR 3 ENGINE "A" LOOP FIRE DETECTION SYSTEM FAULT LIGHT ILLUMINATED. GAUGE FLUCTUATING. ITEM TRANSFERED TO DMI 181 PER MEL REF 26-1 CAT "C" DUE ON 8/7/11 PLACARDS INSTALLED. REPLACED NR 3 ENG "A" LOOP FIRE DETECT CARD IAW MM 26-10-00 PG 401 OPS CK OK IAW MM SDR UALA2011072803897Fire Detector · malfunctionedFWD CARGO DET 1 AND 2 FAIL. MADE INPOERATIVE IAW MEL. PERFORMED LOWER CARGO BITE PROCEDURE PER MM. NO DEFECTS NOTED.SDR SIMA201121003Smoke Detector · malfunctionedON FLIGHT 3906 THE CREW REPORTED AN ENGINE NR 1 FIRE DETECTOR FAIL MESSAGE. THE AIRCRAFT WAS REMOVED FROM SERVICE. PERFORMED OPERATIONAL CHECK OF THE ENGINE FIRE DETECTOR SYSTEM IAW EMB 145 AMM 26-10-00 AND GENERAL VISUAL INSPECTION OF E1 FIRE DETECTOR IAW STSDR C2XA11CL173Warning System · malfunctionedCLE FLT 2250 THE CREW REPORTED AN APU FIRE DETECT FAIL MESSAGE ON THE EICAS DURING TAXI. THE AIRCRAFT RETURNED TO THE GATE. MAINTENANCE INSPECTED PLACED THE APU FIRE DETECT SYSTEM AND THE APU ON MEL. SUPPLEMENT TO FOLLOW.
Back to JASC 2612