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 AWXA200400170Slide · leakingPHX - EES - DURING 4-DAY CHECK MAINTENANCE FOUND THE L-4 DOOR SLIDE BOTTLE PRESSURE IN RED ZONE. MAINTENANCE REMOVED AND REPLACED L-4 DOOR SLIDE ASSEMBLY IAW T/C R1C25602.SDR GTIA040146Slide · dislodgedDTW - FOUND R1 SLIDE PACK FELL OFF. RESECURED R1 DOOR SLIDE PACK, NO DEFECTS NOTED. (M)SDR SWAA040434Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA040423Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R1, L1 AND R2 DOOR EVAC SLIDES OUT OF ADJUST. ADJUSTED ALL 3 DOOR EVAC SLIDES PER MM.SDR GTIA040047Lanyard · misroutedFLL - R-1 DOOR EMERGENCY SLIDE GIRT BAR LANYARD ROUTED INCORRECTLY. RE-ROUTED R-1 DOOR SLIDE GIRT BAR LANYARD. (M)SDR SWAA040395Slide · out of adjustDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA040394Slide · out of adjustUNABLE TO SEE L2 DOOR EVAC SLIDE PRESSURE GAUGE AFTER MULTIPLE REINSTALL ATTEMPTS. REMOVED AND REPLACED L2 DOOR EVAC SLIDE PER MM.SDR SWAA040376Slide · malfunctionedL1 DOOR EVAC SLIDE PARTIALLY DEPLOYED AT GATE. REMOVED AND REPLACED L1 DOOR EVAC SLIDE PER MM.SDR SWAA040374Slide · unserviceableR2 DOOR EVAC SLIDE PRESSURE LOW INDICATION. REMOVED AND REPLACED R2 DOOR EVAC SLIDE PER MM.SDR GTIA040050Lanyard · disconnectedRSW - FOUND R1 DOOR LANYARD OFF. RECONNECTED R1 DOOR SLIDE LANYARD. NO DEFECTS NOTED. (M)SDR GTIA040049Lanyard · looseFLL - FOUND R-1 DOOR EVACUATION SLIDE LANYARD LOOSE. RE-INSTALLED R-1 DOOR EVACUATION SLIDE LANYARD. (M)SDR UPS04141852Girt Bar · detachedMAIN ENTRY DOOR SLIDE EMERGENCY ESCAPE SLIDE RELEASE MECHANISM SLIDER & GIRT BAR DETACHED FROM DOOR. GRIT BAR HANGING FROM SLIDE ASSY. RE-ATTACHED GRIT BAR & SLIDER TO ESCAPE SLIDE PER MM 52-10-30-4 (6), OK FOR CONTINUED SERVICE.SDR GTIA040051Lanyard · looseFLL - FOUND R1 DOOR EVACUATION SLIDE LANYARD LOOSE. REINSTALLED R1 DOOR EVACUATION SLIDE LANYARD. (M)SDR SWAA040371Slide · unserviceableL2 DOOR EVAC SLIDE PRESSURE INDICATION LOW. REMOVED AND REPLACED L2 DOOR EVAC SLIDE PER MM.SDR SWAA040369Slide · looseR1 DOOR EVAC SLIDE LOOSE. RE-INSTALLED R1 DOOR EVAC SLIDE PER MM.SDR 2004UALA00098Support Fitting · brokenDOOR 2L WILL NOT DISARM. ONE OF THE CASTINGS THAT LIFT THE SLIDE GIRT BAR WHEN ACTUATED BY THE DOOR ARM/DISARM LEVER, WAS FOUND BROKEN, PREVENTING THE SLIDE GIRT BAR FROM BEING LIFTED FREE OF THE FLOOR GIRT FITTING. THE FITTING WAS REPLACED AND THE GIRT BAR SDR SWAA040352Slide · dislodgedR1 DOOR EVAC SLIDE FELL OUT OF CONTAINER. INSTALLED SLIDE IN CONTAINER PER MM.SDR ASAA0480078Lanyard · disconnectedOKC - DURING HV-6 CHECK, FOUND AFT EXIT TAIL EMERGENCY ESCAPE SLIDE FAILED TO DEPLOY DURING OPERATIONAL CHECK. LANYARD PULLED LOOSE FROM SLIDE PACK COVER, AND COVER REMAINED IN POSITION. S/D - INVESTIGATION SUGGESTS THAT THE PROBABLE CAUSE OF FAILURE WAS A WSDR 2004UALA00099Slide · deployedTHE 2R EMERGENCY EVACUATION SLIDE PARTIALLY DEPLOYED. DOOR 2R SLIDE/RAFT PARTIAL DEPLOYMENT OCCURRED DURING SLIDE INSTALLATION. DURING INSTALLATION SEQUENCE THE DOOR WAS ARMED, THEN WAS INADVERTENTLY OPENED SUFFICIENT TO RELEASE THE SLIDE PACK. AMM PROVIDES ASDR SWAA040345Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040341Slide · out of adjustDURING SCHEDULED A1 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040339Fitting · inoperativeL2 DOOR EVAC SLIDE GIRT BAR BRACKET SPRING INOP. REMOVED AND REPLACED L2 DOOR EVAC SLIDE BRACKET PER MM.SDR AWXA200400141Slide · delaminatedDURING THRU FLIGHT INSPECTION FOUND THE LT OVERWING EMERGENCY EXIT SLIDE DELAMINATED. MAINTENANCE REMOVED AND REPLACED LT OVERWING EMERGENCY EXIT SLIDE IAW T/C R1A25301.SDR MWEA040015Indicator · inoperativeFORWARD ENTRANCE DOOR SLIDE PRESSURE GAUGE IS INOPERATIVE. REMOVED AND REPLACED FORWARD EVACUATION SLIDE.SDR SWAA040336Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR GTIA040043Slide · dislodgedMCO - FLT 1913 - L1 SLIDE FELL OUT OF DOOR PANEL. RE-INSTALLED L1 SLIDE PACK AND COVER. (M)SDR SWAA040330Hook · shearedDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EVAC SLIDE GIRT BAR HOOK FASTENER SHEARED. REMOVED AND REPLACED RETAINER HOOK PER MM.SDR SWAA040326Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040324Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR 2004UALA00729Bottle · dischargedLOW BOTTLE PRESSURE. CAUSE NOT FOUND. BOTTLE TOPPED OFF AND CHECKED FOR LEAKS. OSV, WINSLOW, HAS ADDED ULTRASONIC LEAK DETECTION TO BOTTLE INSPECTION PROCESS. THERE WAS NO FAULT FOUND.SDR SWAA040307Bottle · lowDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EVAC SLIDE BOTTLE PRESSURE LOW. REMOVED AND REPLACED R2 DOOR EVAC SLIDE PER MM.SDR USAASA04010Slide · deployedPRIOR TO DEPARTURE, THE MAIN ENTRY DOOR WAS OPENED WHILE THE SLIDE WAS ARMED. THE SLIDE DID NOT INFLATE. MAINTENANCE REMOVED THE SLIDE AND DEPLETED THE AIR PRESSURE FROM THE CYLINDER. AIRCRAFT FERRIED FOR MAINTENANCE TO PIT. THE SLIDE WAS REPLACED. IN THESDR SWAA040287Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040278Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR ASAA0480031Lanyard · disconnectedSEA PREFLIGHT CHECK, FOUND AFT SERVICE DOOR L2 EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR SWAA040271Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA040270Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L1 DOOR AND R2 DOOR EVAC SLIDES OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA040264Slide · out of adjustDURING SCHEDULED A1 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA040263Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR AWXA200400153Slide · looseMCN - EES - DURING C-03 CHECK FOUND THE R-1 DOOR SLIDE CONTACTING THE FUSELAGE BEFORE THE DOOR WOULD FULLY OPEN. MAINTENANCE FOUND THE R-1 DOOR SLIDE LACING BECAME RELAXED. REMOVED AND REPLACED R-1 DOOR SLIDE IAW T/C C1C52309, OPERATIONAL CHECK WAS GOOD.SDR ASAA0480030Lanyard · disconnectedSEA - DURING PREFLIGHT CHECK, FOUND FORWARD PAX L-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR GTIA040032Slide · looseFLL - FLT 679 - L1 DOOR SLIDE NOT ATTACHED AT BOTTOM SIDE. REINSTALLED L1 DOOR SLIDE. (M)SDR UPS04141787Slide · malfunctionedINSPECTION TYPE:N/A DOOR SLIDE DIFFICULT TO ARM ON LAST 2 LEGS. CHECKED ESCAPE SLIDE ARM IAW MM 25-61-20-5, FOUND SATISFACTORY. LUBRICATED TELESCOPIC UNIT IAW MM 12-22-52, CHECKED OK.SDR AALA20040145Slide · displacedAUS L2 AFT SERVICE DOOR SLIDE FOUND BELOW GREEN BAND ON A CHECK. REPLACED L2 AFT SERVICE DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR DL757040078Slide · dislodgedTHE 1R DOOR OPENED WHILE STILL ARMED, R1 DOOR ASSIST BOTTLE DISCHARGED. R1 DOOR FULLY OPENED, BUT SLIDE PACK FELL ON TO CATERING TRUCK PLATFORM AND DID NOT DEPLOY. REPLACED SLIDE PACK.SDR SWAA040244Slide · dislodgedL1 DOOR EVAC SLIDE INADVERTENTLY FELL OUT OF HOUSING. REINSTALLED L1 DOOR EVAC SLIDE INTO HOUSING PER MM.SDR SWAA040236Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040225Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040224Slide · dislodgedL1 DOOR EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA040220Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.
Back to JASC 2565