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 USAAF00046Slide · dislodgedGSP - UPON OPENING DOOR ON ARRIVAL, THE ESCAPE SLIDE FELL OUT, BUT DID NOT DEPLOY. MAINTENANCE REPLACED PASSENGER DOOR ESCAPE SLIDE. (M)SDR AU000599Slide · malfunctioned(AUS) DURING TEST, NR 1 LT SLIDE RAFT MOORING LINE TANGLED WITH THE ASPIRATOR. INVESTIGATION FOUND THAT THE SLIDE MOORING LINE WAS NOT ATTACHED TO THE GIRT BAR. PERSONNEL/MAINTENANCE ERROR.SDR AU000518Slide · faulty(AUS) NR 1 LT SLIDERAFT MOORING LINE TANGLED WITH ASPIRATOR.SDR SWAA001111Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR AT0000323Slide · looseFOUND GALLEY DOOR SLIDE PACK LOOSE. REINSTALLED R-1 EVACUATION SLIDE.SDR SWAA001110Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER DUE TO GIRT BAR NOT PROPERLY STOWED TO CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001109Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER DUE TO GIRT BAR NOT PROPERLY STOWED TO CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR AT0000306Slide · dislodgedFOUND L-1 DOOR SLIDE PACK FELL OUT. REINSTALLED L-1 DOOR SLIDE PACK, IAW DC9 MM 25-62.SDR SWAA001102Girt Bar · out of adjDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001101Indicator · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001098Indicator · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001097Slide · dischargedFWD SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR BELOW LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR 2000UALA00336Slide · damagedDOOR 1 SLIDE/RAFT DEVELOPED SEAM BLISTERS IN BOTH THE SLIDE/RAFT INFLATABLE DOOR SILL PILLOWS DURING SHOP OVERHAUL. THE CAUSE OF THE SEAM BLISTERS IS UNKNOWN. UNIT IS BEING SENT TO THE VENDOR FOR EVALUATION AND REPAIR.SDR 2000UALA00335Slide · leakingDOOR 1 SLIDE FAILED AIR RETENTION TEST WHILE IN THE HOME SHOP FOR OVERHAUL. THE FAILURE OF THE SLIDE TO PASS THE AIR RETENTION TEST WAS CAUSED BY POROSITY IN THE INFLATABLE MATERIAL. THE SLIDE IS BEING SCRAPPED.SDR DLM88001147Slide · deployedR1 DOOR SLIDE BLEW WHEN OPENING DOOR. SLIDE WAS LEFT ARMED. REPLACED SLIDE.SDR SWAA001085Indicator · out of positionFWD SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001084Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER DURING DOOR CLOSING. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001083Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE FOUND OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001079Slide · deployedDURING SCHEDULED RON, AFT SERVICE DOOR EVACUATION SLIDE DEPLOYED INADVERTENTLY. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA001063Indicator · out of positionFWD ENTRY DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001072Indicator · out of positionAFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR AALA006097Pin · looseLAX - PIN ON FORWARD DOOR SLIDE FALLING OUT. REINSTALLED GIRT BAR ATTACH PIN OK FOR SERVICE. (M)SDR SWAA001068Girt Bar · out of adjDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001061Slide · dislodgedAFT ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001058Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001056Indicator · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA001054Girt Bar · out of adjDURING SCHEDULED C3 CHECK, FOUND BOTH FWD ENRTY AND SERVICE DOOR EVACUATION SLIDE GIRT ASSY''S OUT OF ADJUST. REINSTALLED SLIDE ASSY''S PER MM.SDR SWAA001044Cover · looseFWD SERVICE DOOR EVACUATION SLIDE COVER CASE LOOSE. SECURED CASE PER MM.SDR SWAA001050Girt Bar · out of adjDURING SCHEDULED C4 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. REINSTALLED SLIDE ASSY PER MM.SDR SCNA00053Slide · failedDURING A ROUTINE MAINTENANCE CHECK, THE R4 DOOR SLIDE WAS CHECKED FOR FOR PROPER INFLATION AND SERVICIABILITY. THE SLIDE DID NOT STAY INFLATED AND SHOWED SIGNS OF DRY ROT ON THE UNDERSIDE OF THE SLIDE, AS WELL AS A SPLIT IN THE MIDDLE OF THE SLIDE PATH. THE SDR SWAA001039Indicator · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY AND SERVICE DOOR EVACUATION SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED BOTH SLIDES PER MM.SDR SWAA001038Cable · misroutedAFT ENTRY DOOR EVACUATION SLIDE GIRT BAR RELEASE CABLE OUT OF POSITION. REROUTED CABLE PER MM.SDR SWAA001037Clip · brokenAFT SERVICE DOOR EVACUATION SLIDE GIRT BAR ATTACH CLIP BROKEN. REMOVED AND REPLACED CLIP PER MM.SDR SWAA001036Indicator · out of positionAFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR 2000UALA00307Slide · splitDURING SHOP OVERHAUL OF THE SLIDE RAFT, (P/N 7A1479-3) (S/N G185) A FOUR INCH SEAM SEPARATION DEVELOPED IN THE LOWER TUBE. THE SEPARATION IS BETWEEN THE LOWER TUBE ASPIRATOR FILL TUBE AND THE MAIN LOWER TUBE. THE UNIT WAS SENT TO THE VENDOR FOR EVALUATION SDR USAAF00044Slide · detachedCLT - FOUND FORWARD SERVICE DOOR SLIDE FALLING OUT OF SLIDE PACK. MAINTENANCE REPLACED SLIDE ASSY. OK FOR SERVICE. (M)SDR SWAA001021Girt Bar · out of adjDURING SCHEDULED C4 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001020Girt Bar · out of adjDURING SCHEDULED C4 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001010Slide · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA000994Girt Bar · out of adjDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000989Slide · dischargedDURING SCHEDULED RON, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR LOW. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA000981Girt Bar · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF POSITION. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000980Girt Bar · wornDURING SCHEDULED C3 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT ASSY WORN. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR TWAA0008411Slide · deployedDURING OVERNIGHT LAYOVER, THE TAIL SLIDE WAS DEPLOYED. SLIDE NOT DISARMED BY FLIGHT ATTENDANT. REPLACED SLIDE ASSEMBLY. AC02 5-2-00 JFK.SDR SWAA000973Cable · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SERVICE DOOR GIRT BAR RELEASE CABLE OUT OF POSITION. REROUTED CABLE PER MM.SDR SWAA000965Girt Bar · out of adjFWD ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000961Slide · deployedFWD ENTRY DOOR EVACUATION SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA000964Girt Bar · out of adjDURING SCHEDULED C1 CHECK, FOUND BOTH ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. REPOSITIONED BOTH SLIDES PER MM.SDR SWAA000963Slide · dischargedDURING SCHEDULED SERVICE CHECK, FOUND BOTH FWD DOOR EVACUATION SLIDE PRESSURE INDICATORS LOW. REMOVED AND REPLACED BOTH SLIDE ASSY''S PER MM.SDR AALA20000997Bottle · dischargedBOS - DURING OVERNIGHT CHECK, L1 DOOR SLIDE PRESSURE LOW. REPLACED L1 DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to JASC 2565