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 SWAA031952Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND BOTH RT CABIN SVC DOOR EMERGENCY EVAC SLIDES OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA031950Indicator · out of positionDURING SCHEDULED A2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031946Slide · out of limitsDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031945Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDES OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR USAASA03099Frame · crackedBWI - THE LEFT OVERWING SLIDE WAS FOUND TO HAVE A CRACK IN THE OUTER FRAME. MAINTENANCE REPLACED THE LEFT OVERWING SLIDE. OK FOR SERVICE. (M)SDR SWAA031930Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. ADJUSTED SLIDE ASSY PER MM.SDR SWAA031914Slide · out of positionFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER AS DOOR WAS OPENED. REINSTALLED SLIDE PER MM.SDR ASAA0380565Lanyard · disconnectedSJC PREFLIGHT CHECK, FOUND FORWARD PAX L1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR SWAA031905Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR 03FDEA01392Slide · deployedDOOR L1 OPENED PROPERLY, HOWEVER "EMERGENCY SLIDE" AT LEFT FRONT ENTRANCE DOOR (L1) DID NOT DEPLOY UPON ACTIVATION. MANUAL HANDLE WAS LIKEWISE UNSUCCESSFUL. FACT 06AUG03 16:47 ABQ R REMOVED OLD SLIDE AND INSTALLED SERVICABLE SLIDE ASSY IAW M/M 25-61-21-SDR SWAA031899Slide · deployedFWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031897Light · inoperativeEEPLS INOP AT OVERWING EMERGENCY EXIT. REPAIRED EEPLS PER MM.SDR SWAA031910Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND BOTH CABIN SVC DOORS EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED BOTH SLIDES PER MM.SDR SWAA031909Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR P5CA0300927Slide · failedRIGHT UPPER DECK SLIDE ASSY FAILED TO DEPLOY DURING MC CHECK. NEW SLIDE INSTALLED.SDR AALA20030899Spring · wornUPON ARRIVAL JFK, R4 DOOR ASSIST BOTTLE BLOWN. SLIDE DID NOT DEPLOY. FOUND AFT SPRING ON GIRT BAR WORN. REPLACED GIRT BAR ASSEMBLY AND DOOR ASSIST BOTTLE AND SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SWAA031894Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR AWXA200300973Proximity Sensor · defectiveFLIGHT CREW REPORTED THE L-2 DOOR SLIDE WOULD NOT ARM FOR DEPARTURE. MAINTENANCE REMOVED AND REPLACED THE L-2 DOOR SLIDE ARM PROXIMITY SENSOR (7WN1) IAW AMM 52-73-11-401, OPERATIONAL TEST WAS GOOD.SDR SWAA031884Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR P5CA0300926Slide · deployedFLT DECK LT ESCAPE SLIDE DEPLOYED INADVERTENTLY. REPLACED SLIDE ASSY, REPLACED SLIDE GAS GENERATOR BOTTLE AND REPLACED DOOR (SLIDE) ASSIST BOTTLE.SDR ASAA0380560Lanyard · damagedSEA PREFLIGHT CHECK, FOUND FORWARD SERVICE R1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND BROKEN. REPLACED LANYARD. (M)SDR SWAA031873Slide · out of positionDURING SCHEDULED RON, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031883Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA031859Handle · looseAFT SVC DOOR EMERGENCY EVAC SLIDE PULL HANDLE LOOSE. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031854Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031853Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER WHEN OPENING THE DOOR. REINSTALLED SLIDE PER MM.SDR AALA20030874Connector · looseSLIDE HANDLE EMERGENCY LIGHT INOPERATIVE. RESEATED LOOSE CONNECTOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SWAA031848Slide · unserviceableDURING SCHEDULED RON, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR UPS03141127Battery · failedINSPECTION TYPE:N/A ESCAPE SLIDE FAILED BATT LOAD TEST. TC 256120-02-1-L-200. REMOVED AND REPLACED IAW A300 AMM 25-61-21.SDR USAASA03092Release Cable · wrong partTHE FORWARD RIGHT EMERGENCY ESCAPE SLIDE WAS FOUND TO HAVE AN INCORRECT RELEASE CABLE INSTALLED DURING INSPECTION. MAINTENANCE REPLACED THE SLIDE ASSEMBLY. OK FOR SERVICE. THE REPAIR SHOP INSTALLED THE PROPER RELEASE CABLE ON THE SLDIE AND RETURNED THE SLIDSDR USAASA03093Release Cable · wrong partTHE AFT RT EMERGENCY ESCAPE SLIDE WAS FOUND TO HAVE AN INCORRECT RELEASE CABLE INSTALLED DURING INSPECTION. MAINTENANCE REPLACED THE SLIDE ASSEMBLY. OK FOR SERVICE. THE REPAIR SHOP INSTALLED THE PROPER RELEASE CABLE ON THE SLIDE AND RETURNED THE SLIDE TO SESDR AWXA200300992Reservoir · brokenDURING C-03 CHECK THE LT OVER WING ESCAPE SLIDE RESERVOIR INFLATION CABLE CONNECTOR WAS FOUND BROKEN. MAINTENANCE REMOVED AND REPLACED THE RESERVOIR ASSEMBLY, OPERATIONAL CHECK WAS GOOD.SDR AWXA200300939Lanyard · tornON DECENT, EN ROUTE FROM PHX THE FLIGHT ATTENDANT REPORTED A LOUD SQUEAL COMING FROM THE L-2 DOOR. MAINTENANCE FOUND THE L-2 DOOR SLIDE LOWER LANYARD TORN AND IN THE DOOR SEAL, AIRCRAFT WAS MAINTENANCE FERRIED BACK TO PHX WHERE THE L-2 DOOR SLIDE WAS REMOVED ASDR SWAA031842Slide · out of adjustDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031840Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA031833Slide · unserviceableFWD ENTRY DOOR EMERGENCY EXIT EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031845Slide · out of adjustFWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR ASAA0380554Lanyard · disconnectedPDX PREFLIGHT CHECK, FOUND FORWARD PAX L-1 DOOR EMERGENCY SLIDE LANYARD WAS DISCONNECTED. RECONNECTED LANYARD. (M)SDR CA030827008Nut Plate · missing(CAN) L-2 DOOR ESCAPE SLIDE GIRT BAR FORWARD FLOOR FITTING NUT PLATE ASSY MISSING, UNDER FLOOR PANEL. THIS NUT PLATE REENFORCED THE GIRT BAR FITTING ATTACHMENT TO THE FLOOR. IN CASE OF CHUTE DEPLOYEMENT, THE LOAD IN THE SLIDE WOULD PULL ON THE ATTACH FITTING ASDR SWAA031818Slide · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR ABXA030327Slide · out of positionAFTER CLOSING ENTRY DOOR, ENTRY DOOR ANNUNCIATOR LIGHT ON. WENT TO RESECURE DOOR AND UPON OPENING, EMERGENCY SLIDE BEGAN TO FALL OUT OF DOOR. MAINTENANCE INSPECTED GIRT BAR MECHANISM. NO DEFECTS NOTED AT THIS TIME. REPLACED L1 SLIDE ASSEMBLY IAW B767 MM 25-66-SDR SWAA031803Slide · out of positionDURING SCHEDULED RON, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031814Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA031813Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031802Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA031799Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MMSDR CALA0300458Slide · unserviceableINSPECTION FOUND THE L-2 DOOR EMERGENCY SLIDE PRESSURE LOW. THE EMERGENCY ESCAPE SLIDE WAS REMOVED AND REPLACED IAW MM 25-61-35.SDR USAASA03088Slide · defectivePHL - RECEIVED 'EPSU EXT LOAD AFT L' FAULT DURING THE EMERGENCY LIGHTS TEST. MAINTENANCE REPLACED THE AFT LEFT SERVICE DOOR EMERGENCY ESCAPE SLIDE. OPERATIONALLY CHECKS OK. (M)SDR SWAA031782Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA031779Indicator · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE PER MM.
Back to JASC 2565