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 GTIA040467Lanyard · disconnectedL2 DOOR SLIDE PACK NEEDS REATTACHED. REATTACHED L2 SLIDE PACK LANYARD.SDR SWAA041429Slide · out of positionR2 DOOR EVAC SLIDE FELL OUT, DID NOT DEPLOY. REINSTALLED R2 DOOR EVAC SLIDE PER MM.SDR SWAA041416Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR ASAA0480443Slide · failedOKC - C-CHECK, AFT SERVICE (L-2) DOOR EMERGENCY SLIDE FAILED TO INFLATE FULLY DURING DEPLOYMENT TEST IAW WK CARD 28525002. SLIDE ASSY WAS REPLACED INSP OF THE REMOVED ASSY REVEALED A DENTED ASPIRATOR. ASSY WAS OVERHAULED, INCLUDED REPLACEMENT OF ASPIRATOR, PSDR SWAA041412Slide · out of adjustR2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR AALA20040564Slide · unserviceablePHX - FORWARD SERVICE DOOR SLIDE PRESSURE BELOW GREEN ARC. REPLACED SLIDE AT FORWARD SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR 2004UALA00539Slide · deployedFORWARD BOTTLE DISCHARGED WHEN PINS WERE PULLED RESULTING IN SLIDE DEPLOYMENT. UNABLE TO DEFINITIVELY DETERMINE CAUSE OF FAILURE DUE TO PARTIAL DEPLOYMENT OF SLIDE. SUSPECT THAT INFLATION CABLE WAS MISROUTED, RESULTING IN TENSION WHICH DEPLOYED SLIDE WHEN BOSDR SWAA041383Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR SWAA041381Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EVAC SLIDE CABLE MISROUTED. REROUTED L2 DOOR EVAC SLIDE CABLE PER MM.SDR SWAA041379Slide · out of adjustDURING SCHEDULED A1 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA041375Slide · lowL2 DOOR EVAC SLIDE PRESSURE LOW PRESSURE INDICATION. REMOVED AND REPLACED L2 DOOR EVAC SLIDE PER MM.SDR SWAA041365Fitting · corrodedDURING SCHEDULED 1/2D CHECK, FOUND L2 AND R1 DOOR EVAC SLIDES FWD AND AFT GIRT BAR FITTINGS CORRODED. REMOVED AND REPLACED EVAC SLIDE GIRT BAR FITTINGS PER MM.SDR SWAA041363Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA041362Slide · out of adjustL1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR UPS04142379Warning Light · inoperativeINSPECTION TYPE:N/A REF M280836 & WAN 892403, EVAC SLIDE WARNING LIGHT INOP. T/S IAW TSM 52-73-00-0 & PERFORMED OPERATIONAL TEST IAW MM 52-73-00-5 & CHECKED NORMAL WITH NO FAULTS.SDR CA040513004Slide · misinstalledADDITIONAL PARTS P/N D30854 S/N 0278 AND P/N 61571 S/N 0175, DURING OVERHAUL INSPECTION BY AIR CRUISERS ALL 3 SLIDES WERE FOUND IMPROPERLY PACKED WITH IMPROPER RESTAINTS. THIS COULD HAVE A SERIOUS PROBLEM IF UNITS WERE DEPLOYED.SDR GTIA040601Slide · damagedFTW - FOUND TAILCONE EVAC SLIDE UNPACKED AND MISSING O/H DATE. REMOVED TAILCONE EVAC SLIDE. INSTALLED TAILCONE EVAC SLIDE. (M)SDR SWAA041361Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR SWAA041356Fitting · corrodedDURING SCHEDULED D CHECK, FOUND L1 DOOR EVAC SLIDE GIRT BAR FITTINGS, CORRODED. REMOVED AND REPLACED L1 DOOR EVAC SLIDE GIRT BAR FITTINGS PER SRM.SDR USAASA04083Slide · damagedBFM - THE ESCAPE SLIDE WAS REMOVED FOR TIME. MAINTENANCE FOUND THE JUNCTION SEAM BRIDGING IS COMING APART AT RUNWAY END UPPER TUBE. SLIDE WAS RETURNED TO VENDOR FOR REPAIR. THE SLIDE WAS REPAIRED AT THE VENDOR AND RETURNED TO THE SLIDE SHOP. THE SLIDE OVERSDR SWAA041349Cover · crackedR1 DOOR EVAC SLIDE PRESSURE IND LENS COVER CRACKED. REMOVED AND REPLACED LENS COVER PER MM.SDR SWAA041346Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EVAC SLIDE CABLE MISROUTED. REROUTED L2 DOOR EVAC SLIDE CABLE PER MM.SDR SWAA041343Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR SWAA041332Slide · out of adjustDURING SCHEDULED PM CHECK, FOUND R1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA041330Slide · out of adjustL2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR GTIA040441Slide · out of positionR1 SLIDE FELL OFF DOOR WHEN OPENED BY CATERING. REINSTALLED SLIDE.SDR SWAA041320Slide · out of adjustR2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR YENA200427Panel · looseAIRFRAME VIBRATION NOTED IN FLIGHT, GW-138,000 LBS / AUTO THRUST ON/OFF, AIRSPEED - MACH .78 THRU .81 (IAS 250 KTS), ENGINE VIB 1 - 1.5 / 0.1, ENGINE VIB 2 - 1.6 / 0.3, PHASE OF FLIGHT - CLIMB & CRUISE, TURB / NO, NO ECAM OSCILLATION, AP 1 - ON SWITCHED TO AP SDR SWAA041305Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA041303Slide · dislodgedL1 DOOR EVAC SLIDE FELL OUT OF CONTAINER, DID NOT DEPLOY. REINSTALLED L1 DOOR EVAC SLIDE PER MM.SDR SWAA041301Slide · out of adjustL1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR SWAA041289Slide · out of adjustDURING SCHEDULED RON, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR AMTA200400532Lanyard · misinstalledUNABLE TO DISARM DOOR 1R. FOUND ROPE/LANYARD TO BE INPROPERLY STOWED ON SLIDE AND WAS INTERFERING WITH THE GIRT BAR. STOWED ROPE/LANYARD PROPERLY, AND OPS CHECKED PER AMM 52-11-25. OPS CHECK NORMAL. (M)SDR SWAA041285Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND L2 DOOR EVAC SLIDE CABLE MISROUTED. REROUTED L2 DOOR EVAC SLIDE CABLE PER MM.SDR SWAA041280Slide · out of adjustDURING SCHEDULED RON, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR UPS04142361Lever · jammedSLIDE LEVER JAMMED AND COULD NOT DISARM SLIDE. ADJUSTED GIRT BAR FITTING PER MM 52-10-11-5, OPS CK GOOD.SDR USA2004F00033Girt Bar · detachedTHE MAIN ENTRY DOOR SLIDE GIRT BAR WAS FOUND DETACHED. MAINTENANCE ATTACHED GIRT BAR. OK FOR SERVICE.SDR SWAA041278Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA041277Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND L2 DOOR EVAC SLIDE CABLE MISROUTED. REROUTED L2 DOOR EVAC SLIDE DOOR CABLE PER MM.SDR GTIA040449Strap · frayedAFT TAIL SLIDE PACK COVER HOLD DOWN STRAP FRAYED AND PRESS GAUGE NOT IN WINDOW. REMOVED AND REPLACED FRAID COVER HOLD DOWN STRAP ON AFT TAILCONE SLIDEPACK. ADJUSTED PACK COVER SO GAUGE WAS VISIBLE.SDR SWAA041281Slide · dislodgedDURING SCHEDULED RON, L1 DOOR EVAC SLIDE FELL OUT OF CONTAINER, SLIDE DID NOT DEPLOY. REINSTALLED L1 DOOR EVAC SLIDE PER MM.SDR SWAA041257Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR ABXA040170Spring · failedMAIN ENTRY DOOR ESCAPE SLIDE DEPLOYMENT BAR WOULD NOT STAY UP. REPLACED DEPLOYMENT BAR GAS SPRINGS. OPS CHECKED GOOD IAW B767 AMM 26-66-01.SDR AWXA200400472Slide · leakingFLIGHT CREW REPORTED THE L-2 DOOR SLIDE PRESSURE WAS LOW. MAINTENANCE REMOVED AND REPLACED THE L-2 DOOR SLIDE ASSEMBLY IAW T/C R1C25304, OPERATIONAL CHECK WAS GOOD.SDR BI0001Link · deployedUPON OPENING SLIDE FOR RECEIVING INSPECTION, IT WAS DISCOVERED THAT ALL THE FRANGIBLE LINKS HAD BEEN DEPLOYED PREVIOUSLY, THEN TIED TOGETHER WITH BREAK AWAY THREAD. THERE IS NO PROCEDURE IN THE CMM FOR THIS TYPE OF REPAIR. THE FRANGIBLE LINKS SHOULD HAVE BEESDR AUS20040367Slide · failed(AUS) DOOR 2L ESCAPE SLIDE LIGHTS FAILED TO ILLUMINATE FOLLOWING SLIDED EMPLOYMENT. SUSPECT FLAT BATTERY.SDR UPS04142327Light · inoperativeCREW ENTRY DOOR EVAC SLIDE RELEASE WARNING SYSTEM LIGHTS WILL NOT TEST. BUZZERS OK. CLEANED DEBRIS FROM SWITCH NOW OPS GOOD PER MM 52-73-00. THIS CLEARS M280249. LP 234452SDR SWAA041254Lens · looseR2 DOOR EVAC SLIDE PRESSURE GAUGE VIEWING LENS LOOSE. SECURED R2 DOOR LENS PER MM.SDR SWAA041252Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR AWXA200400459Slide · defectivePHX - EEL/EES - DURING 4-DAY CHECK EMERGENCY LIGHT TEST FAILED WITH AFT LT BATTERY INDICATING FAULTS AT EXTERIOR LOADS. MAINTENANCE REMOVED AND REPLACED L-2 DOOR SLIDE ASSEMBLY IAW T/C R1C25301, LIGHT TEST WAS GOOD.
Back to JASC 2565