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 = '2565' 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 = '2565' 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 SWAA040033Slide · deployedUPON OPENING L1 DOOR, EVACUATION SLIDE DEPLOYED. REMOVED AND REPLACED L1 DOOR EVACUATION SLIDE PER MM.SDR SWAA040037Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R1, L1 AND L2 DOORS EVACUATION SLIDE GIRT BAR ASSEMBLIES OUT OF ADJUST. ADJUSTED R1, L1 AND L2 DOORS EVACUATION SLIDE PER MM.SDR 2004F00332Slide · deployedAFTER PARKING, R1 SLIDE DEPLOYED INADVERTANTLY BY CREW AFTER PASSENGERS DEPLANED AND CLEANING CREW WAS ONBOARD. REMOVED AND REPLACED SLIDE IAW BMM 25-60-15. (M)SDR AUS20040072Battery · discharged(AUS) NR 3R DOOR ESCAPE SLIDE EMERGENCY LIGHTING FAILED TO ILLUMINATE. INVESTIGATION FOUND THE BATTERY FLAT.SDR GTIA040230Pin · out of positionFTW - FOUND TAILCONE SLIDE WILL NOT DEPLOY WHEN TAILCONE IS RELEASED. REPOSITIONED CLEVIS TOGGLE PINS ON AFT EMERGENCY EXIT SLIDE. (M)SDR WRLA200401Aspirator · separatedDURING MAINTENANCE CHECK, AT GSO, THE REQUIRED TEST DEPLOYMENT OF THE R1 DOOR EVACUATION SLIDE WAS ACCOMPLISHED. DURING TEST THE AFT ASPIRATOR OF THE SLIDE CAME APART. FOUND THE RETAINING RING THAT HOLDS THE ASPIRATOR IN PLACE ON THE SLIDE CAME OUT WHEN THE SDR GTIA040143Slide · unserviceableFTW - FOUND R1 DOOR SLIDE REQUIRES REPACK. REMOVED R1 DOOR SLIDE. INSTALLED NEW R1 DOOR SLIDE. (M)SDR GTIA040002Slide · damagedLGA - FOUND L2 DOOR SLIDE DAMAGED AND ON THE RAMP FLOOR NEXT TO 2 BAGS OF GARBAGE. REMOVED AND REPLACED L2 DOOR SLIDE PACK, OK FOR SERVICE. (M)SDR 2004UALA00724Valve · dischargedLOW BOTTLE PRESSURE. PRESSURE RELIEF VALVE DEFECTIVE. PRESSURE GAUGE WAS REPLACED WHICH INCLUDED REPLACEMENT OF PRESSURE RELIEF VALVE. OSV, WINSLOW, HAS ADDED ULTRASONIC LEAK DETECTION TO BOTTLE INSPECTION PROCESS.SDR ASAA040002Lanyard · disconnectedLAS - DURING PREFLIGHT CHECK, FOUND AFT SERVICE L2 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR GTIA040003Slide · dislodgedFLL - FLT 1581 - L2 SLIDE PACK CAME OFF DOOR UPON LANDING. L2 SLIDE PACK WAS REINSTALLED. (M)SDR GTIA040001Slide · looseFGA - FLT 866 - L2 SLIDE PACK NEEDS REATTACHMENT. REATTACHED L2 SLIDE PACK. (M)SDR SWAA040002Slide · out of adjustFOUND L1 DOOR EVACUATION SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVACUATION SLIDE PER MM.SDR AMTA200400001Slide · malfunctionedFOUND DOORS 4L, 2R SLIDE WILL NOT ARM. OPENED AND CLOSED DOOR, SLIDE ARMED AS REQUIRED. OPS CHECK NORMAL. (M)SDR GTIA031070Slide · tornLGA - R1 DOOR ESCAPE SLIDE RIPPED ALONG GIRT BAR. REMOVED AND REPLACED R1 DOOR ESCAPE SLIDE. (M)SDR DL76G031149Battery · dischargedON PDC FOUND LEFT SLIDE AND RIGHT SPOILER SQUIBS NOT TESTING IN COCKPIT. REPLACED BATTERY PACK AT 22G, CHECKS NORMAL.SDR SWAA032830Slide · dislodgedR1 DOOR EVACUATION SLIDE FELL OUT OF CONTAINER INADVERTENTLY. REINSTALLED SLIDE ASSY PER MM.SDR WX0300025Slide · deployedIN PREPARATION FOR DEPARTURE FROM CZM, THE CAPT GAVE THE OK TO CLOSE DOORS. DOORS CLOSED AND THE SLIDES ARMED AND THE CAPTAIN WAS NOTIFIED ACCORDINGLY. AS THE LEAD FLIGHT ATTENDANT WAS PREPARING TO DO THE SAFETY BRIEFING, THE COCKPIT DOOR OPENED AND THE FIRSSDR GTIA031052Slide · out of positionSJU - FLT 770 - L2 SLIDE PACK FELL OFF OF DOOR. REINSTALLED L2 SLIDE PACK. (M)SDR SWAA032821Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L2 DOOR EVACUATION SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA032820Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L1 DOOR EVACUATION SLIDE OUT OF ADJUST. READJUSTED SLIDE ASSY PER MM.SDR SWAA032818Slide · out of adjustDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR EVACUATION SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE PER MM.SDR 2004UALA00721O-Ring · failedLOW BOTTLE PRESSURE. BOTTLE TO VALVE O-RING WAS DETERIORATED. REPLACED CYLINDER ASSY. OSV, WINSLOW, HAS ADDED ULTRASONIC LEAK DETECTION TO BOTTLE INSPECTION PROCESS.SDR SWAA032809Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EVACUATION SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE PER MM.SDR SWAA032806Slide · out of adjustR2 DOOR EVACUATION SLIDE IS OUT OF ADJUSTMENT. ADJUSTED R2 SLIDE PER MM.SDR SWAA032803Slide · out of adjustR2 DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF POSITION. READJUSTED SLIDE ASSY PER MM.SDR UPS03141669Connector · looseINSPECTION TYPE: PFLT, DURING STATIC WARNING TEST RED LIGHT DID NOT ILLUMINATE, TOW WAS HEARD. *SUPPLEMENTAL* RESEATED C/P ON THE AUTONOMOUS STANDBY POWER SUPPLY UNIT. OPS CHECKS GOOD PER MM 52-73-00. THIS CLEARS M273081. REFERENCE LP 141511.SDR SWAA032799Slide · out of positionR2 DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA032798Slide · out of positionR2 DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR AWXA200301588Slide · misalignedWHILE CATERING WAS OPENING THE L-2 DOOR THE EMERGENCY ESCAPE SLIDE UNRAVELED ON GALLEY FLOOR AND CATERING TRUCK RAMP, DOOR WAS NOT OPENED ALL THE WAY AND SLIDE NEVER DEPLOYED. MAINTENANCE WAS CALLED OUT AND FOUND THE GIRT BAR NEVER DETACHED FROM THE AIRCRAFT ESDR F3LA200300187Battery Pack · failedDURING C-7 CHECK, INSPECTION REPORTED FWD GALLEY DOOR ESCAPE SLIDE BATTERY PACK FAILED VOLTAGE TEST. REPLACED FWD GALLEY DOOR ESCAPE SLIDE.SDR SWAA032760Slide · deployedINADVERTANT DEPLOYMENT OF L2 DOOR EVACUATION SLIDE BY CLEANING CREW. REMOVED AND REPLACED L2 DOOR EVACUATION SLIDE PER MM.SDR SWAA032773Slide · out of adjustL2 DOOR EVACUATION SLIDE OUT OF ADJUSTMENT. ADJUSTED L2 DOOR EVACUATION PER MM.SDR SWAA032756Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L2 DOOR EVACUATION SLIDE OUT OF POSITION. ADJUSTED SLIDE ASSY PER MM.SDR DL757031093Slide · faultyTHE 1R DOOR SLIDE LIGHT REMAINS ILLUMINATED AFTER SLIDE IS IN DISARMED POSITION. SLIDE DID NOT DEPLOY PROPERLY. REPLACED SLIDE, ASSIST BOTTLE, FWD PROX SWITCH AND FWD GIRT BAR FOOT.SDR SWAA032754Slide · out of adjustR2 DOOR EVACUATION SLIDE OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR UPS03141667Slide · malfunctionedINSPECTION TYPE:N/A MAIN CABIN DOOR SLIDE INOPERABLE REF UPS03641656 VOIDED BECAUSE TAIL NUMBER SHLD HAD BEEN N137UP INSTEAD OF N320UP. INSTALLED DUAL ESCAPE SLIDE TO DOOR PER Z831 PER MM 25-61-21-4, CLEARS M272188.SDR SWAA032731Slide · out of adjustDURING RON, FOUND R1 DOOR EVACUATION SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE PER MM.SDR SWAA032730Slide · out of limitsL2 DOOR SLIDE PRESSURE GAUGE IN THE RED. REMOVED AND REPLACED L2 DOOR SLIDE PER MM.SDR SWAA032722Slide · out of adjustGAUGE ON SLIDE AT L2 DOOR OUT OF ADJUSTMENT. ADJUSTED SLIDE PER MM.SDR SWAA032710Slide · out of adjustL1 DOOR SLIDE OUT OF ADJUSTMENT. READJUSTED L1 SLIDE PER MM.SDR SWAA032712Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L2 DOOR SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE PER MM.SDR SWAA032681Slide · out of adjustDURING SCHEDULED D CHECK, FOUND L2 ESCAPE SLIDE OUT OF ADJUSTMENT. ADJUSTED L2 SLIDE PER MM.SDR SWAA032672Slide · lowDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR EVACUATION SLIDE PRESSURE INDICATION LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA032669Slide · out of adjustR2 DOOR EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE ASY PER MM.SDR AALA20031404Slide · failedDFW UNSUCCESSFUL SLIDE DEPLOYMENT. DIRECTIONAL EXIT HANDRAIL DID NOT FULLY INFLATE AND DID NOT STAY INFLATED. REPLACED RIGHT HAND MAIN OFFWING EVACUATION SLIDE ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR SWAA032659Indicator · out of positionR1 DOOR EVACUATION SLIDE PRESS INDICATOR NOT VISIBLE. READJUSTED SLIDE PER MM.SDR 2004UALA00727Indicator · defectiveLOW BOTTLE PRESSURE. CAUSE WAS DEFECTIVE GAUGE. CORRECTIVE ACTION TAKEN WAS SLIDE BOTTLE REPLACED WITH NEWLY OVERHAULED BOTTLE AND ULTRASONIC LEAK DETECTION IMPLEMENTED FOR BOTTLE INSPECTION.SDR 2003UALA00929Battery Pack · misinstalledRIGHT EMERGENCY ESCAPE SLIDE SQUIB WILL NOT TEST. EVENT CAUSED BY IMPROPERLY INSTALLED BATTERY PACK.SDR 2004UALA01178Aspirator · crushedBOTH ASPIRATORS WERE CRUSHED DURING THE PACKING PROCEDURE OF THE PREVIOUS OVERHAUL. ASPIRATOR DAMAGE LIKELY CAUSED BY EXCESSIVE PRESSURE APPLIED DURING THE PREVIOUS PACKING PROCESS. NO INDICATIONS OF SHIPPING DAMAGE. BOTH ASPIRATORS WERE REPLACED.
Back to JASC 2565