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 USAASA00013Slide · malfunctionedBOS - FOUND FORWARD LEFT ESCAPE SLIDE FAILED EMERGENCY LIGHT CHECK. CIDS DISPLAYED EPSU EXT LOAD FWD LT. MAINTENANCE REPLACED THE FORWARD LEFT ESCAPE SLIDE. OPERATIONAL CHECK OK. (M)SDR SWAA000624Girt Bar · corrodedDURING SCHEDULED HALF D CHECK, FOUND FWD SERVICE DOOR BOTH EVACUATION SLIDE GIRT BAR FLOOR ATTACH BRACKETS CORRODED. R&R BOTH BRACKETS PER MM.SDR SWAA000612Slide · dislodgedAFT SERVICE DOOR EVACUATION SLIDE FALLING OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR CA000330002Slide · failed(CAN) DURING SCHELDULED DEPLOYMENT OF ESCAPE SLIDE, SLIDE DID NOT COMPLETLY DEPLOY. FABRIC COVER ON THE PACKBOARD JAMMED THE CABLE. SLIDE REPLACED.SDR SWAA000596Indicator · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000595Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000594Indicator · out of positionFWD ENTRY DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR AU000347Wire Rope · frayed(AUS) AFT SERVICE DOOR SLIDE RELEASE CABLE FRAYED IN THE LOOP WHERE ITATTACHES TO THE LATCH. FOUND DURING INSPECTION IAW AD/B737/42.SDR CIHA200096001Battery Pack · dischargedL-1 DOOR AND R-1 DOOR EMERGENCY SLIDE LIGHTS ARE INOP.SDR USAAF00028Slide · inoperativeALB - THE FORWARD SERVICE DOOR WAS INADVERTENTLY DEPLOYED, BUT THE SLIDE DID NOT INFLATE. MAINTENANCE REPLACED THE FORWARD SERVICE DOOR SLIDE. (M)SDR SWAA000582Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR AWXA0000184Slide · deployedON ARRIVAL AT TUS, SLIDE WAS DEPLOYED (DID NOT INFLATE). REPLACED ESCAPE SLIDE IAW CARD R1C25305. TT 0064631 RECOMMENDATION: REMAIN OPEN PENDING REVIEW OF TEARDOWN REPORT. NO HISTORY.SDR AALA006057Slide · dislodgedESCAPE SLIDE PACK HAS COME OFF OF R-1 (FWD GALLEY) DOOR. SECURED HARD PACK QUICK RELEASE MECH. SLIDE PACK OK FOR SERVICE. (M)SDR SWAA000581Indicator · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SERVICE DOOR PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000580Bracket · looseDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR BOTH EVACUATION SLIDE GIRT BAR FLOOR ATTACH BRACKET, AND BOTH AFT BRACKETS IN AFT ENTRY AND SERVICE DOORS LOOSE. SECURED BRACKETS PER MM.SDR SWAA000579Indicator · out of positionAFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000566Girt Bar · shortedAFT SERVICE DOOR EVACUATION SLIDE GIRT BAR WOULD NOT ENGAGE IN FLOOR BRACKETS. ADJUSTED GIRT ASSY LENGTH PER MM.SDR CALA0000343Battery · inoperativeINSPECTION FOUND EMERGENCY ESCAPE SLIDE LIGHTS AT DOOR R-1, R-2, AND L-2 WEAK DURING TEST. THE SLIDE LIGHT BATTERIES WERE REPLACED AND OPERATION CHECKED GOOD IAW MM 25-60-00.SDR ABXA000171Slide · deployedENTRY DOOR EMERGENCY SLIDE DID NOT FULLY INFLATE WHEN ACCIDENTLY DEPLOYED. REPLACED ENTRY DOOR ESCAPE SLIDE PACK IAW B767 MM 25-66-01-04.SDR USAAF00027Girt Bar · damagedRIC - FOUND THE FORWARD SERVICE DOOR WILL NOT ARM PROPERLY. MAINTENANCE FOUND ARMING MECHANICAL LINKAGE BOUND AT DOOR OPEN/CLOSING HANDLE INTERFACE POINT. FREED LINKAGE AT INTERFACE/STICKING POINT. DOOR OPS CHECKED OK. (M)SDR SWAA000576Bracket · looseDURING SCHEDULED BC2 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT BAR STOW BRACKETS LOOSE. SECURED BRACKETS PER MM.SDR MWEA00182Slide · dislodgedAFT GALLEY SERVICE DOOR EMERGENCY EVACUATION SLIDE IS DISLODGED FROM ITS COVER. MAINTENANCE REINSTALLED SLIDE PACK.SDR SWAA000570Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR MWEA00181Slide · stuckUPON ARRIVAL AT GATE, FLIGHT ATTENDANT COULD NOT DISARM AFT GALLEY SERVICE DOOR EMERGENCY EVACUATION SLIDE. MAINTENANCE CLEANED AND LUBRICATED GIRT BAR LATCH.SDR 20000619AP013Slide · deployedFLT 7200 - KEF-CVG - UPON ARRIVAL CVG, PARITAL DOOR SLIDE DEPLOYMENT ON L-1 DOOR. SLIDE DID NOT INFLATE. HOWEVER, DEPLOYMENT MECHANISM WAS PARTIALLY TRIGGERED. REPLCED L-1 ESCAPE SLIDE. (M)SDR SWAA000562Bracket · looseDURING SCHEDULED C3 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT BAR FLOOR ATTACH BRACKETS LOOSE. TIGHTENED BRACKETS PER MM.SDR SWAA000557Slide · dischargedDURING SCHEDULED RON, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR LOW. R&R SLIDE ASSY PER MM.SDR SWAA000554Slide · deployedFWD SERVICE DOOR EVACUATION SLIDE PARTIALLY DEPLOYED ON THE GROND. R&R SLIDE ASSY PER MM.SDR SWAA000552Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR MWEA00180Slide · dislodgedFOUND FORWARD GALLEY SERVICE DOOR EMERGENCY EVACUATION SLIDE DISLODGED FROM ITS COVER. MAINTENANCE REINSTALLED EMERGENCY EVACUATION SLIDE.SDR MWEA00179Slide · dislodgedFOUND FORWARD CABIN DOOR EMERGENCY EVACUATION SLIDE DISLODGED FROM ITS COVER. MAINTENANCE REINSTALLED EVACUATION SLIDE.SDR SWAA000537Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000535Cable · looseDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE RELEASE CABLE ATTACH BOLT LOOSE. TIGHTENED BOLT PER MM.SDR SWAA000534Bracket · looseDURING SCHEDULED C4 CHECK, FOUND BOTH AFT DOOR EVACUATION SLIDE GIRT BAR FLOOR ATTACH BRACKETS LOOSE. TIGHTENED BRACKETS PER MM.SDR TWAA0004501Slide · deployedIN THE PROCESS OF CLOSING THE L-1 DOOR THE ESCAPE SLIDE DEPLOYED. INSTALLED SEVICEABLE SLIDE PER MD9-25-03. AC-03 01-11-00 JFK.SDR SWAA000525Slide · looseFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR MWEA00176Slide · dislodgedAFT GALLEY SERVICE DOOR EMERGENCY EVACUATION SLIDE CAME LOOSE FROM ITS HOUSING. MAINTENANCE REINSTALLED AFT GALLEY SERVICE DOOR SLIDE.SDR SWAA000527Hook · looseDURING SCHEDULED BC4 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT BAR ATTACH HOOKS LOOSE. RESECURED GIRT BAR HOOKS PER MM.SDR 0004225514Slide · rupturedDURING SLIDE SHOP TEST AT OPERATING PRESSURE, INFLATABLE SEAM RUPTURED AT DOG LEG. SLIDE WILL BE OVERHAULED AND RECEIVE A NEW INFLATABLE.SDR SWAA000530Slide · looseDURING SCHEDULED C2 CHECK, FOUND BOTH ENTRY DOOR EVACUATION SLIDE GIRT ASSY'S OUT OF ADJUSTMENT. REINSTALLED BOTH SLIDES PER MM.SDR SWAA000529Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000522Slide · dislodgedAFT ENTRY DOOR EVACUATION SLIDE CAME OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000519Slide · looseDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT OUT OF ADJUSTMENT. REINSTALLED SLIDE ASSY PER MM.SDR AALA006048Slide · dislodgedRNO - DOOR L-1 SLIDE CAME OFF DOOR. REMOVED AND REPLACED L1 SLIDE PER MM, P/N D29982-113 S/N OFF 1823, S/N ON 0472. (M)SDR SWAA000508Bracket · looseDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY AND SERVICE DOOR GIRT BAR FLOOR ATTACH BRACKETS LOOSE. RETORQUED BRACKETS PER MM.SDR AU000473Slide · malfunctioned(AUS) RT UPPER DECK ESCAPE SLIDE FAILED TO CORRECTLY DEPLOY.SDR AU000199Slide · will not test(AUS) RT UPPER DECK ESCAPE SLIDE FAILED TO OPERATE CORRECTLY DURING TEST.SDR DL72K000507Slide · dischargedL2 DOOR SLIDE LOW PRESSURE. REPLACED SAME.SDR SWAA000492Indicator · dislodgedAFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000491Indicator · dislodgedAFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.
Back to JASC 2565