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 SWAA020827Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR DL757020456Bottle · inoperativeEMERGENCY ESCAPE TEST 2 BOTTLE PRESSURE INOP ON RIGHT SIDE. REPLACED BOTTLE ASSY PER M/M, TESTS GOOD.SDR SWAA020809Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. RE INSTALLED SLIDE PER MM.SDR SWAA020818Slide · unserviceableDURING SCHEDULED PM CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020808Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER INADVERTENTLY. RE INSTALLED SLIDE PER MM.SDR SWAA020805Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR HOOK BRACKET CORRODED. REMOVED AND REPLACED HOOK BRACKET PER SRMSDR SWAA020797Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020796Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020778Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020776Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020769Slide · unserviceableFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR ASAA0280134Lanyard · detachedSEA - DURING PREFLIGHT CHECK, L-2 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. REATTACHED LANYARD. (M)SDR AT0200048Slide · out of positionR1 DOOR SLIDE OFF. REINSTALLED R1 DOOR SLIDE PACK.SDR SWAA020768Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020760Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020758Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020750Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020728Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020738Slide · unserviceableDURING SCHEDULED A2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020725Cable · frayedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR CABLE FRAYED. REMOVED AND REPLACED CABLE PER MM.SDR 0201139981Slide · failedGROUND SERVICE AGENT DROPPED THE TAIL CONE WHILE TRYING TO GAIN ENTRY INTO THE AIRCRAFT. THE EVACUATION SLIDE DID NOT DEPLOY WHEN THE TAIL CONE DROPPED. MAINTENANCE REPLACED THE TAIL CONE. DROPPED CHECK TESTED THE TAIL CONE AND SLIDE ASSEMBLY AND THE SLIDE SDR SWAA020724Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020718Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020717Slide · 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 ASAA0280139Lanyard · detachedPHX - DURING PREFLIGHT CHECK, L1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. REATTACHED LANYARD. (M)SDR SWAA020704Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR DL757020394Slide · failedON ARRIVAL L2 DOOR WAS NOT DISARMED AND DOOR WAS OPENED. DOOR ASSIST BOTTLE FIRED AND SLIDE PACK REMAINED UNINFLATED. PINNED BOTTLE AND REMOVED SLIDE PACK ASSY 715913. REPLACED SLIDE AND DOOR EMERGENCY POWER RESERVOIR PER M/M 393247.SDR SWAA020673Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR AUS20020297Bottle · discharged(AUS) FORWARD RT DOOR SLIDE INFLATION BOTTLE HAD NO PRESSURE.SDR SWAA020656Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR 0201096624ReservoirWHILE FLAT FIRING THE DOOR SLIDE ASSEMBLY PRIOR TO OVERHAUL, THE RESERVOIR DELAYED THREE SECONDS AFTER THE MANUAL FIRING LANYARD WAS PULLED. OVERHAULED THE DOOR SLIDE.SDR SWAA020655Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE PRESS IND'S OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA020654Bracket · corrodedDURING SCHEDULED D CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE, BOTH FWD AND AFT GIRT BAR BRACKETS CORRODED. REMOVED AND REPLACED BRACKETS PER MM.SDR SWAA020653Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020646Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020642Bracket · brokenDURING SCHEDULED 1/D CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE MOUNTING BRACKET BROKEN. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA020638Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020637Bracket · crackedDURING SCHEDULED BC1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE FWD SUPPORT BRACKET CRACKED. REPAIRED BRACKET PER SRM.SDR AT0200040Slide · unserviceableDURING SERVICE CHECK FOUND TAIL CONE EVACUATION SLIDE PRESSURE LOW. REMOVED AND REPLACED EVACUATION SLIDE IAW DC9 MM 25-62.SDR SWAA020636Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA020627Slide · out of adjustFWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020624Slide · 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 SWAA020623Bracket · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE FWD FLOOR ATTACH BRACKET CRACKED. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA020622Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020606Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020609Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020628Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020610Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR ASAA0280097Lanyard · disconnectedSEA - FORWARD SERVICE R-1 DOOR EMERGENCY SLIDE LANYARD DISCONNECTED. REATTACHED LANYARD. (M)SDR SWAA020608Bracket · looseDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE FLOOR GIRT BRACKET LOOSE. SECURED BRACKET PER MM.
Back to JASC 2565