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 98ZZZX3006Restraint · misinstalledEVACUATION SLIDE RECEIVED PACKED WITH SHEAR PIN RESTRAINTS INSTALLED. RECEIVING INSPECTION REVEALED THE SHEAR PIN RESTRAINTS WERE PREVIOUSLY ACTIVATED. THE TWO HALVES OF THE SHEAR PIN RESTRAINTS WERE RE-ATTACHED WING STEEL SAFETY WIRE. ONCE SHEAR PIN RESTRASDR 98ZZZX3534Slide · deployedYYZ - FLT 6001 - LEFT NR 1 DOOR EVACUATION SLIDE DEPLOYED. INADVERTENT DEPLOYMENT ON GROUND. REMOVED AND REPLACED EVACUATION SLIDE.SDR AU981151Lanyard · frayed(AUS) ESCAPE SLIDE COVER RELEASE CABLES FRAYED AT BOTH AFT DOORS. FOUND DURING INSPECTION IAW AD/B737/42.SDR USAAF98061Slide · malfunctionedPIT - DURING AN ANNUAL ESCAPE SLIDE OPERATIONAL CHECK SAMPLING PROGRAM, THE FORWARD ENTRY DOOR ESCAPE SLIDE DID NOT FULLY INFLATE. ACCORDING TO THE INSPECTOR THAT WITNESSED THE DEPLOYMENT, THE SLIDE INITIALLY WAS HUNG UP IN THE DOORWAY. WHEN THE MANUAL HANDLSDR G60A025Sensor · failedTHE L1 DOOR EVACUATION SLIDE REMOTE PRESSURE PRESS TO TEST SWITCH WAS INOPERATIVE. THIS WAS DEFERRED IAW MEL 25-24. GROUND MAINTENANCE REMOVED AND REPLACED THE PRESSURE SENSE ASSY IAW MM 25-60-03. OPERATIONAL CHECK NORMAL. (M)SDR AALA981408Slide · malfunctionedPVD - FLT 1974 - FORWARD ENTRY DOOR SLIDE FOUND ON FLOOR WITH PINS POPPED OUT. DID NOT INFLATE. INSTALLED NEW DOOR SLIDE PACK. SYSTEM GROUND CHECKED NORMAL. (X)SDR SWAA981365Slide · missingDURING WALKAROUND CHECK, FOUND FWD SVC DOOR HAS NO EMERGENCY EXIT SLIDE. REMOVED AND REPLACED PER BOEING MM.SDR SWAA981364Slide · low pressureDURING WALKAROUND CHECK, FOUND REAR ESCAPE SLIDE PRESS LOW. REMOVED AND REPLACED PER BOEING MM.SDR ASAA9880128Bottle · inopPDX - DURING MAINTENANCE CHECK, THE TAILCONE EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE TAILCONE EMERGENCY EVACUATION SLIDE ASSY. (M)SDR MWEA98770Slide · inoperativeTHE FORWARD SERVICE DOOR SLIDE FAILED AMP TEST. MAINTENANCE REMOVED AND REPLACED FORWARD SERVICE DOOR EMERGENCY SLIDE.SDR SWAA981334Slide · deployedDURING WALKAROUND CHECK, FOUND FORWARD ENTRY DOOR SLIDE DEPLOYED. REMOVED AND REPLACED FWD ENTRY DOOR SLIDE ASSY PER BOEING MM.SDR AALA981833Slide · failedSJU - FLT 574 - AFTER TAKEOFF SJU EN ROUTE TO MIA, THE NR 1 ENGINE EXPERIENCED A FIRE. CREW DECLARED AN EMERGENCY AND SHUT ENGINE DOWN. AIRCRAFT AIR INTERRUPTED BACK TO SJU AND LANDED WITHOUT FURTHER INCIDENT. AFTER AIRCRAFT CAME TO A STOP AN EMERGENCY EGRESDR MWEA98763Slide · inoperableTHE GALLEY SERVICE DOOR ESCAPE SLIDE PRESSURE GAUGE IS IN RED AREA. MAINTENANCE REPLACED GALLEY DOOR SLIDE.SDR 98UAL900310Slide · deployedNUMBER 1 RIGHT DOOR SLIDE DEPLOYED. *S/D* INADVERTENT DEPLOYMENT DUE TO HUMAN ERROR. DEPLOYMENT WAS NORMAL. SLIDE WAS REPLACED.SDR AALA981299Slide · failedORD - FLT 1928 - AFT GALLEY EMERGENCY SLIDE DEPLOYMENT WIRE BROKEN. REPLACED AFT GALLEY DOOR EMERGENCY SLIDE PER MM. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)SDR 99ZZZM598Slide · crackedLEFT FORWARD EVAC SLIDE PACK BOARD CRACKED AT TOP MOUNT PP PIN. REMOVED SLIDE ASSY AND PLACED ON W/O, P/N 31050-105, S/N 0093, REF W/C 8012 FOR INSTALLATION. (M)SDR GTIA9800074Slide · separatedTPA - FLT 341 - PASSENGER ENTRANCE DOOR SLIDE PACK FELL OFF. RE-INSTALLED PASSENGER DOOR ENTRANCE SLIDE PACK IAW DC9 MM 25. (X)SDR ASAA9880116Slide · malfunctionedOAK - DURING C-CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (X)SDR GTIA9800073Slide · separatedDTW - FLT 172 - RIGHT GALLEY PACK SLIDE OFF. INSTALLED L2 DOOR SLIDE PACK IAW DC9 MM 25-61-0. RII ACCOMPLISHED. (X)SDR DL757981312Slide · malfunctionedTHE LEFT SLIDE INADVERTANTLY DEPLOYED BY FLIGHT CREW. SLIDE DID NOT FULLY INFLATE. REPLACED SLIDE.SDR VJ9800200Cable · detachedDURING PREFLIGHT, FOUND THE FWD LOADING DOOR CHUTE CABLE DETACHED. REINSTALLED L-1 DOOR SLIDE IAW MM 25-62-0.SDR DLM88981309Slide · defecyiveL2 DOOR SLIDE BOTTLE PRESS LOW. REPLACED DOOR SLIDE.SDR AALA981187Slide · damagedBOS - DURING OVERNIGHT MAINTENANCE R2 DOOR HARD TO ARM. SNAPS ON SLIDE WHERE BUSTLE ATTACHES BROKEN AND INTERFERRING WITH SLIDE ARMING OPERATION. REPLACED R2 DOOR SLIDE. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)SDR 98ZZZX3981Slide · damagedPACKBOARD BENT CAUSING SLIDE COVER NOT TO RELEASE, RIGHT AFT POSITION. REMOVED AND REPLACED SLIDE.SDR DLM11981259Pins · pulledFOUND L2 DOOR SLIDE PINS PULLED OUT OF SLIDE PACK. REPLACED PACK.SDR DL72W981260Slide · inoperative2R PASSENGER DOOR SLIDE PRESSURE LOW. REPLACED SLIDE ASSY.SDR SWAA981118Slide · missingDURING SCHEDULED SERVICE CHECK, FOUND FWD GALLEY DOOR ESCAPE SLIDE MISSING. REINSTALLED AFT ENTRY DOOR AND FWD AFT GALLEY DOOR ESCAPE SLIDE. REMOVED AND REPLACED PER BOEING MM.SDR AALA981170Slide · malfunctionedMIA - FLT 1531 - AT GATE PRIOR TO DEPARTURE, THE R1 DOOR SLIDE CAME APART AND DID NOT INFLATE. REPLACED R1 DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SCNA98054Slide · failedDURING DEPLOYMENT OF THE R4 DOOR SLIDE FOR TRAINING PURPOSES THE SLIDE FAILED TO INFLATE FULLY.SDR SCNA98053Slide · failedDURING DEPLOYMENT OF THE R4 DOOR SLIDE FOR TRAINING PURPOSES THE SLIDE FAILED TO INFLATE FULLY.SDR AU981150Lanyard · frayed(AUS) DOOR L2 ESCAPE SLIDE COVER RELEASE CABLE FRAYED. FOUND DURING INSPECTION IAW AD/B737/42.SDR USAAF98060Slide · rupturedPIT - DURING AN ANNUAL ESCAPE SLIDE OPERATION CHECK SAMPLING PROGRAM, THE FORWARD ENTRY DOOR SLIDE FAILED TO HOLD INFLATION PRESSURE DUE TO TWO HOLES IN THE SLIDE. THE SLIDE DEPLOYED NORMALLY AND ALL SLIDE LIGHTS ILLUMINATED. IT COULD NOT BE DETERMINED IF THSDR ASAA9880096Slide · failedPHX - DURING C-CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR SWAA980971Slide · deployedDURING WALKAROUND CHECK, FOUND FWD SERVICE DOOR ESCAPE SLIDE ACCIDENTALLY DEPLOYED AFTER ENGINES/SHUT DOWN. REPAIRED PER BOEING MM.SDR ORJA98254Slide · failedAT MHV, C-CHECK L-1 DOOR SLIDE FAILS LIGHT SYSTEM CHECK PER CARD. REMOVED AND REPLACED DEFECTIVE L-1 DOOR SLIDE PER MM 25-62-00. OPS CHECK GOOD. (M)SDR 98UAL900217Cable · brokenLEFT HAND OVERWING SLIDE DOOR OPEN AND SLIDE PARTIALLY DEPLOYED. *S/D* INADVERTANT DEPLOYMENT DURING OVERWING EXIT HATCH WINDOW SHADE EXCHANGE. REASON FOR PARTIAL DEPLOYMENT IS THE SWAGED END OF THE INFLATION CABLE SEPARATED FROM CABLE. REPLACED CABLE.SDR AU980676Regulator · faulty(AUS) NR 3 LT OFFWING ESCAPE SLIDE SLOW TO DEPLOY. INVESTIGATION FOUND THAT THE INFLATION CYLINDER REGULATOR WAS AFFECTED BY `O' RING FRICTION.SDR AALA981010Slide · deployedIAH - WHILE AT THE GATE, THE FORWARD SERVICE DOOR EMERGENCY SLIDE WAS INADVERTENTLY ACTIVATED AND FAILED TO FULLY DEPLOY. REPLACED FORWARD SERVICE DOOR EMERGENCY SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR CALA9800853Slide · low pressureDOOR R 4 SLIDE PACK PRESSURE LOW OUT OF GREEN BAND. REMOVED AND REPLACED SLIDE PACK PER MM 25-66-01.SDR CALA9800844Slide · failedTAIL CONE DEPARTED AIRCRAFT AND SLIDE FAILED TO COMPLETELY DEPLOY. REPLACED SLIDE AND TAIL CONE ASSEMBLY PER MM 25-63-01 AND 53-53-00.SDR CALA9800824Slide · jammedR2 DOOR JAMMED IN DOORWAY DURING SAMPLE SLIDE DEPLOYMENT, SLIDE COVER HIT DOOR JAMB. REPLACED SLIDE AND ASSIST BOTTLE PER CAL WORKCARDS.SDR ORJA9890Slide · low pressureFORWARD GALLEY ESCAPE SLIDE PRESSURE IS BELOW OPERATING LIMITS. REMOVED AND REPLACED FORWARD GALLEY ESCAPE SLIDE. (M)SDR ASAA9880080Inflation Bottle · low pressurePDX - DURING MAINTENANCE CHECK, THE L2 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED L2 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR ASAA9880079Inflation · low pressurePDX - DURING MAINTENANCE CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR 98UAL900176Tube · failed testDURING SHOP OVERHAUL OF SLIDE/RAFT IT FAILED THE AIR RETENTION TEST. FAILURE DUE TO A SEAM LEAK IN THE UPPER TUBE ON THE LOWER END CROSS OVERTUBE LOWER SEAM UNDER CHAFING PANEL. SLIDE/RAFT SENT TO VENDOR FOR REPAIR.SDR 98UAL900175Tube · failed testDURING SHOP OVERHAUL OF SLIDE/RAFT, IT FAILED THE AIR RETENTION TEST. FAILURE DUE TO POROSITY IN THE UPPER TUBE INFLATABLE MATERIAL. SLIDE/RAFT SENT TO VENDOR FOR REPAIR.SDR 9807969969Slide · low pressureDURING PERIODIC CHEDK, FOUND MAIN CABIN DOOR EVACUATION SLIDE BOTTLE PRESSURE LOW. REPLACED SLIDE.SDR CA980602021Slide · deployed(CAN) UPPER DECK R/H SLIDE ASSY ACCIDENTLY DEPLOYED DUE FLIGHT CREW L/H AND R/H UPPER DECK DOORS ARMED UPON ARRIVAL. SLIDE DEPLOYED CAUSING DAMAGE TO PACK BOARD. DAMAGE CAUSED BY LANYARD PIN INSTALLED INCORRECTLY ALLOWING BOTTLES TO INITIATE INFLATION PRIORSDR AU981134Slide · malfunctioned(AUS) DOOR L1 LEFT SIDE ESCAPE SLIDE SLOW TO DEPLOY DURING TEST. SUBMITTER SUSPECTS CAUSED BY STICKING OF THE SLIDE REGULATOR PISTON.SDR 99ZZZM515Slide · damagedNR 1 ESCAPE SLIDE PACK BOARD CRACKED AT HINGE POINT (APPROX 5 INCHES) MRR NEEDS FILE. REMOVED AND REPLACED NR 1 SLIDE ASSY PERFORMED COVER PULL TEST AND FOUND SERVICEABLE. UPDATED BATTERY EFF CHECKED FOR INSTALLED SLIDE S/N 0238. DOOR ARM CHECK C/W. NO DEF
Back to JASC 2565