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 USAASA01062Slide · unserviceableLGA - THE AFT LEFT SLIDE PRESSURE WAS OUT OF THE GREEN BAND. MAINTENANCE REPLACED THE AFT LEFT SLIDE ASSEMBLY. OK FOR SERVICE. (M)SDR SWAA013164Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTANTLY DEPLOYED. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA013161Slide · out of positionDURING SCHEDULED BC3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA013163Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA013159Slide · unserviceableAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA013157Bracket · brokenFWD SVC DOOR EMERGENCY EVAC SLIDE BAR BRACKET BROKEN. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA013145Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA013128Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA013126Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA013125Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA013111Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR AALA20012049Pin · out of positionTUL - FOUND FORWARD ENTRY DOOR SLIDE FAILED TO DEPLOY DUE TO LANYARD ROLL PIN STICKING OUT LOCKING LANYARD IN FIXED POSITION MAKING SLIDE UNABLE TO DEPLOY. REPLACED DOOR SLIDE AND LANYARD ASSEMBLY. (M)SDR SWAA013113Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA013103Bracket · brokenDURING SCHEDULED 1/4D CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE MOUNT BRACKET BROKEN. R&R MOUNT BRACKET PER MM.SDR SWAA013108Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA013107Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA013106Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA013102Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA013095Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA013094Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA013092Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA013089Slide · deployedDURING SCHEDULED RON, FWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY INFLATED. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA013088Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR ASAA0180300Lanyard · detachedPHX - DURING LINE CHECK, L-1 DOOR EMERGENCY SLIDE GIRT BAR-TO-LATCH LANYARD WAS FOUND DETACHED. REATTACHED LANYARD. (M)SDR SWAA013085Slide · unserviceableDURING SCHEDULED A2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA013083Retainer · looseDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE COVER GIRT BAR HOLDER LOOSE. SECURED HOLDER PER MM.SDR SWAA013070Slide · out of positionFWD ENTRY DOOR EMERGENCY EVC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR 2001UALA02249Wire · chafedLEFT WING SLIDE EICAS MSG AND EMER DOORS LIGHT ILLUMINATED SUPPLEMENTAL DATA UPDATE REPLACED LEFT OVERWING SLIDE DOOR PROX SENSOR S10373. FOUND BAD GROMMET AND CHAFED SENSOR WIRES WHERE WIRES PASS THROUGH SLIDE COMPARTMENT FWD BULKHEAD TO LEFT WHEELWELL. REPSDR SWAA013068Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR DL757011786Pin · bentAFTER TAXI IN LEFT EMERGENCY ESCAPE TEST LIGHT (P61) ON ALL THE TIME. REPLACED P61 PANEL, NO HELP. RE-INSTALLED ORIG. REPLACED RELAY K10486, NO HELP. RE-INSTALLED SIDEWALL AND BOTH HATCHES, REMOVED FOR ACCESS TO P78 PANEL. INSPECTED CANNON PLUG ON PRESSURSDR USAASA01059Slide · faultyMCO - RECEIVED AN 'EPSU EXT LOAD EXIT L' FAULT DURING TEST. MAINTENANCE REPLACED THE L3 DOOR SLIDE ASSEMBLY. OK FOR SERVICE. (M)SDR SWAA013054Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA013051Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA013048Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA013053Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR UPS01837258Slide · inoperativeINSPECTION TYPE:PFLT REF M226149 EMERGENCY ESCAPE SLIDE INOP. REMOVED AND REPLACED ESCAPE SLIDE COVER WITH SERVICEABLE UNIT.SDR SWAA013025Cable · frayedDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE FRAYED. R&R SLIDE CABLE PER MM.SDR SWAA013011Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA013004Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR 2001UALA02231Squib · activatedSUSPECT LEFT SLIDE AND LEFT SPOILER ACTIVATION SQUIBS ACTIVATED. INITIALLY, THE LEFT HAND OFF WING SPOILER OVERRIDE ACTUATOR SQUIB BLEW. THIS ACTUATOR IS ELECTRICALLY FIRED, WHICH INDICATES THAT THE SYSTEM WAS NOT PROPERLY AND COMPLETELY DISARMED PRIOR TO OPSDR SWAA012999Slide · deployedFWD ENTRY DOOR EVACUATION SLIDE DEPLOYED INADVERTENTLY. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA012980Slide · deployedAFT SVC DOOR EMERGENCY EVAC SLIDE DEPLOYED INADVERTENTLY. R&R SLIDE PER MM.SDR DL757011735Slide · failedSLIDE PACK FAILED TO DEPLOY WHEN DOOR OPENED WITH SLIDE ENGAGED. FOUND SLIDE DEPLOY MECHANISM LOCATED ON SLIDE PACK JAMMED NOT ALLOWING DEPLOYMENT. REPLACED SLIDE PACK WITH PART BORROWED FROM UAL.SDR GTIA011076Slide · out of positionFTW - L2 DOOR SLIDE FALLS OFF. INSTALLED SLIDER STOP IAW MD-80 MM 25-62-00. OPS CHECK GOOD. (M)SDR SWAA012975Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. ADJUSTED SLIDE PER MM.SDR SWAA012974Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE PER MM.SDR SWAA012979Slide · out of adjFWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA012942Slide · out of adjFWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA012990Bracket · brokenDURING SCHEDULED 1/4D CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE COVER BRACKET BROKEN. R&R BRACKET PER SRM.SDR UPS01237191Slide · unsecureINSPECTION TYPE:IN DOOR PARTIALLY OPENED FROM EXTERIOR WITH SLIDE ARMED SLIDE FELL FROM DOOR BUT DID NOT DEPLOY. RESECURED SLIDE ASSY.
Back to JASC 2565