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 SWAA021868Slide · out of adjustAFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021866Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021865Slide · unserviceableFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021869Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021863Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENLY DEPLOYED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021861Slide · out of positionDURING SCHEDULED BC4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021853Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021852Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT AS DOOR WAS OPENED. REINSTALLED SLIDE PER MM.SDR SWAA021838Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. REPOSITIONED SLIDE PER MM.SDR SWAA021839Slide · unserviceableDURING SCHEDULED RON, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021837Slide · looseDURING SCHEDULED BC3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE NYLON CORD HANGING OUT OF GIRT AREA. STOWED NYLON CORD PER MM.SDR SWAA021836Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021828Slide · looseDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. REMOVED AND REPLACED SLIDE PER MM.SDR MALA020453Battery Pack · failedAFTER PREVIOUS FLIGHT 3624, RT AFT EVACUATION SLIDE BATTERY PACK FAILED. DURING TASK CARD 0437 INSPECTION. MAINTENANCE INSTALLED SLIDE ASSEMBLY.SDR SWAA021811Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR 02081203Lanyard · displacedLeft Entry Door light came on in flight. Visual inspection showed door not fully closed. Interior handle would pop out of closed detent repeatedly.Found L2 Door Slide Girt/Girt Bar assy. unsecured, reinstalled Girt/Girtbar Assy per M/M 25-66-01. L2 Door ops chSDR USAASA02071Latch · fodENROUTE, THE 2L SLIDE DISARMS IN FLIGHT. MAINTENANCE CLEANED FOREIGN OBJECT DAMAGE FROM GIRT BAR LATCHES. OPERATIONALLY CHECKS GOOD.SDR SWAA021809Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA021801Slide · looseDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA021791Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA021789Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR USAASA02068Slide · malfunctionedENROUTE, DURING FLIGHT, THE SERVICE DOOR BECAMED DISARMED. THE RED WARNING LIGHT FLASHES CONTINUOUSLY IN CABIN DOORS AND CABIN INTERCOM DATA SYSTEM. FLIGHT LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED THE FORWARD SERVICE DOOR SLIDE ASSEMBLY. OPS CSDR 2002UALA01289Bracket · loose'L WING SLIDE' EICAS MESSAGE DISPLAYED INTERMITTENTLY WITH EMERGENCY DOOR OVERHEAD LIGHTS FLICKERING. TARGET ASSY BRACKET FOUND LOOSE IN OFF WING SLIDE COMPARTMENT. SECURED BRACKET.SDR SWAA021767Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021777Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR ZW0A0208501SlideTHE LEFT SIDE FORWARD CABIN DOOR ESCAPE SLIDE HAD LOW BOTTLE PRESSURE. REPLACED THE SLIDE ASSEMBLY. CHECK-C 10-11-01 MCI. --CLOSED--SDR SWAA021768Slide · unserviceableDURING SCHEDULED RON, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021765Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021753Slide · out of adjustAFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021751Slide · unserviceableDURING SCHEDULED PM CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021750Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR DL76G040715Slide · unserviceableLEFT WING OVERWING SLIDE DEPLOYED DURING TAXI FROM HANGAR TO LINE. REPLACED DOOR ACTUATOR.SDR SWAA021736Slide · out of positionDURING SCHEDULED 1/4D CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021734Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE DEPLOYED BY FLIGHT ATTENDANT. REMOVED AND REPLACED SLIDE PER MM.SDR 2002UALA01279Slide · faultyDURING NR 3 SERVICE CHECK OF EMERGENCY LIGHTING SYSTEM FOUND EPSU EXT LOAD AFT L FAULT. POWER SUPPLY SHOWS EXT LOAD FAULT. SUSPECT SLIDE LIGHTS BAD. BOTH SLIDES REPLACED.SDR SWAA021733Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER WHILE OPENING DOOR. REINSTALLED SLIDE PER MM.SDR SWAA021729Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA021740Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA021721Slide · out of adjustFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021718Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021719Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021702Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021701Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE FALLING OUT OF CONTAINER. SECURED SLIDE PER MM.SDR SWAA021708Bracket · looseDURING SCHEDULED CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR BRACKET LOOSE. REMOVED AND REPLACED FWD GIRT BAR BRACKET FASTENERS PER MM.SDR SWAA021685Slide · out of positionAFT SVC DOOR EMERGENCY EXIT EVAC SLIDE INADVERTENTLY WAS PULLED FROM CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021682Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021686Bracket · looseDURING SCHEDULED BC1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK LOOSE. SECURED HOOK PER MM.SDR SWAA021677Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR AALA20021104Slide · deployedTUL - FLT 9603 - EN ROUTE TUL-DFW - AFTER TAKEOFF, RECEIVED EICAS MESSAGE FOR LEFT WING SLIDE PROBLEM. DURING LANDING, AIRCRAFT REQUIRED QUARTER WHEEL DEFLECTION FOR CONTROLLED FLIGHT. RETURNED TUL AND LANDED WITHOUT INCIDENT. REMOVED DEPLOYED OVERWING SLIDSDR 0202459997Slide · malfunctionedTAIL CONE WAS DROPPED AT THE GATE AND THE SLIDE DID NOT DEPLOY AS DESIGNED. THE TAIL CONE DID NOT RECEIVE ANY DAMAGE AND WAS RE-ATTACHED BACK INTO POSITION AND THE AIRCRAFT WAS FERRIED TO ATL FOR SLIDE MAINTENANCE AND RIGGING. PERFORMED COMPLETE ADJUSTMENT A
Back to JASC 2565