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 SWAA022080Fitting · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA022064Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA022063Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED WHEN OPENING DOOR. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA022073Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022072Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022071Slide · misroutedDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW AND SLIDE GIRT CABLE MISROUTED. REPOSITIONED SLIDE AND REROUTED CABLE PER MM.SDR ET32002F00000Retainer · missingDURING INSPECTION FOUND 1 OF 2 SWIVEL NUTS ON THE INFLATION HOSE SEPARATED FROM HOSE AT ASPIRATOR END. INSPECTION REVEALED CAUSE OF SEPARATION, RETAINING RING WAS MISSING. RETAINING RING WOULD HAVE BEEN TRAPPED INSIDE ASPIRATOR INLET. A SEARCH FOR MISSING RSDR GTIA020950Slide · out of positionAFT SERVICE DOOR SLIDE CAME OFF OF DOOR. NEED TO BE REINSTALLED. AFT SERVICE DOOR SLIDE REINSTALLED. (M)SDR SWAA022066Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022069Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022052Slide · defectiveFWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR WOULD NOT LATCH PROPERLY. REMOVED AND REPLACED SLIDE PER MM.SDR 372PA0012SlideR-2 door emergency exit slide out of green band. Inspected and found OK, gage needle is less than one-half of green band to the left, per MM 25-61-35 Pg. 215. R&R R-2 emergy. exit slide IAW 737-300 MM 25-61-35 for convenience.SDR SWAA022169Slide · out of positionDURING SCHEDULED RON, FWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022062Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR 0202879883Slide · failedFIRST OFFICER ATTEMPTED TO LOWER REAR STAIRWAY AND DROPPED THE TAIL CONE INSTEAD. TAIL CONE EVACUATION SLIDE DID NOT DEPLOY OR INFLATE. REPLACED THE SLIDE AND THE TAIL CONE. AIRCRAFT RETURNED TO SERVICE.SDR SWAA022036Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022016Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022000Slide · out of adjustFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022002Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021999Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA022009Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022008Fitting · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR ATTACH FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA022004Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022005Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER WHEN OPENING DOOR. REINSTALLED SLIDE PER MM.SDR SWAA022017Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022003Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER WHEN OPENING DOOR. REINSTALLED SLIDE PER MM.SDR SWAA021980Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA021977Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA021975Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021978Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021973Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA021962Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021959Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED GIRT ASSY'S PER MM.SDR MALA020508Slide · unserviceableLEFT REAR EVAC SLIDE READS ZERO PSI. MAINTENANCE REPLACED LT REAR ESCAPE SLIDE IAW AVRO JOB CARD 0437, ALL CHECKS GOOD IAW AVRO AMM 25-60-11.SDR CALA0200442Slide · unserviceableTHE L1 DOOR EMERGENCY ESCAPE SLIDE PRESSURE WAS OUT OF GREEN BAND. THE SLIDE WAS REMOVED AND REPLACED IAW MM 25-61-35.SDR SWAA021926Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021940Fitting · looseDURING SCHEDULED C4 CHECK, FOUND BOTH CABIN ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTINGS LOOSE. SECURED FITTINGS PER MM.SDR SWAA021927Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA021928Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021917Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER WHEN DOOR WAS OPENED. REINSTALLED SLIDE PER MM.SDR SWAA021931Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR ABXA020116Spring · out of positionDOOR SLIDE ARMING HANDLE WAS DIFFICULT TO ARM. TOOK THREE ATTEMPTS TO RECYCLE MAIN DOOR TWO TIMES. FOUND EVACUATION SLIDE GIRT BAR AFT SPRING OUT OF POSITION. REPOSITIONED SPRING AS REQUIRED. OPS CHECKED NUMEROUS TIMES IAW B767 AMM. OPS CHECKED GOOD.SDR SWAA021919Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021916Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE PRESS IND'S OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA021908Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR ABXA020115Slide · unserviceableEMERGENCY ESCAPE SLIDE ON L1 DOOR HAD NO PRESSURE. REPLACED THE EMERGENCY ESCAPE SLIDE ON L1 DOOR IAW B767 AMM 25-66-01-4.SDR SWAA021905Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA021896Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021895Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021883Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.
Back to JASC 2565