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 SWAA012223Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012212Slide · looseAFT ENTRY DOOR EMERGENCY EVAC SLIDE ASSY LOOSE. SECURED AFT ENTRY EVAC SLIDE ASSY PER MM.SDR 2001UALA01641Slide · deployedMAIN ENTRY DOOR NR 4 RIGHT SLIDE IRREGULAR DEPLOYED DOOR CYLINDER DISCHARGED. DOOR NOT FULLY DISARMED PRIOR OPENING. REPLACED SLIDE.SDR SWAA012240Fitting · brokenDURING SCHEDULED D CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING ANCHOR NUT BROKEN. R&R GIRT BAR FITTING ANCHOR NUT PER MM.SDR SWAA012196Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR UPS01236532Slide · inoperativeINSPECTION TYPE:IN MAIN CABIN SLIDE INOP REF DEF M220206 FWD ENTRY SLIDE DEPLOYED. REPLACED SLIDE AND LATCH ASSY REF 25-60-14.SDR DL73K011284Slide · out of positionL1 DOOR SLIDE CAME OUT OF CASE. C/A REPLACED SLIDE.SDR SWAA012190Slide · out of positionBOTH AFT DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED EVAC SLIDES PER MM.SDR SWAA012221Bracket · corrodedDURING SCHEDULED 1/4D CHECK AT DALFORT, FOUND CORRODED NUTPLATE AT AFT SVC DOOR EMERGENCY EVAC SLIDE AFT MOUNT BRACKET. R&R BRACKET NUTPLATE PER SRM.SDR 2001UALA01642Slide · leakingDOOR 1 RIGHT HAND SLIDE RAFT FAILED AIR RETENTION TEST DURING FIRST SHOP OVERHAUL. FOUND HOLE IN RAFT INFLATABLE LOWER TUBE ASPIRATOR TUBE. HOLE APPEARS TO BE CAUSED DURING PACKING. HOLE WILL BE REPAIRED PER VENDOR'S CMM 25-66-19.SDR USAASB01218Power Unit · failedCLT - DURING ANNUAL OPERATIONAL CHECK OF THE FORWARD RIGHT SERVICE DOOR ESCAPE SLIDE, THE SLIDE DEPLOYED NORMALLY BUT THE SLIDE MOUNTED EMERGENCY LIGHTS FAILED TO ILLUMINATE. SLIDE OPERATIONAL CHECK FAILED. MAINTENANCE FOUND THE POWER UNIT ASSEMBLY FOR THE ESDR SWAA012188Fitting · looseDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR GIRT BAR HOOK FLOOR ATTACH FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA012182Slide · out of positionDURING SCHEDULED RON CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012170Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. INSTALLED EVAC SLIDE PER MM.SDR SWAA012169Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012163Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012141Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA012125Bracket · looseDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR GIRT BAR BRACKET LOOSE. SECURED GIRT BAR BRACKET PER MM.SDR ABXA010409Slide · deployedTHE CREW INADVERTANTLY DEPLOYED THE EMERGENCY ESCAPE SLIDE. NO SLIDE INFLATION. REPLACED THE MAIN ENTRY DOOR SLIDE IAW B767 MM 25-66-00.SDR ZW0A0105901SlideTHE LEFT SIDE NUMBER 1 CABIN DOOR ESCAPE SLIDE PRESSURE WAS LOW. REPLACED THE SLIDE. CHECK-C 5-10-01 STL. --CLOSED--SDR SWAA012110Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA012096Slide · damagedAFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY TORN AND FRAYED. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA012081Slide · unserviceableDURING SCHEDULED RON CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA012083Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. ADJUSTED EMERGENCY EVAC SLIDE PER MM.SDR SWAA012082Slide · unserviceableFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA012067Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA012073Slide · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR ASAA0180225Lanyard · disconnectedSEA - DURING PRE-FLIGHT CHECK, GALLEY SERVICE DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED FROM THE SLIDE COVER. REATTACHED LANYARD BETWEEN GIRT BAR AND DOOR SLIDE COVER. (M)SDR SWAA012059Slide · out of adjFWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. INSTALLED EVAC SLIDE PER MM.SDR SWAA012056Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012046Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF THE CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA012045Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012034Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA012033Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012026Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA012044Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA012031Bracket · looseDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD STOW HOOK ATTACH BRACKET RIVETS LOOSE. SECURED RIVETS PER MM.SDR GTIA010660Slide · defectiveFLL - FLT 171 - L1 SLIDE PACK CAME APART WHEN OPENING AIRCRAFT DOOR. REMOVED AND REPLACED L1 SLIDE ASSEMBLY IAW MM 25-62-00. (M)SDR SWAA012005Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012003Slide · unserviceableDURING SCHEDULED A2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA011994Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA011993Slide · unserviceableDURING SCHEDULED RON CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA012049Cable · misroutedDURING SCHEDULED 1/4D CHECK, FOUND BOTH AFT DOOR EMERGENCY EVAC SLIDE LATCH ASSY CABLES MISROUTED. REROUTED CABLES PER MM.SDR SWAA012016Bracket · shearedDURING SCHEDULED 1/2D CHECK AT DALFORT, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR AFT STOW HOOK ATTACH BRACKET RIVET SHEARED. R&R RIVET PER SRM.SDR ABXA010400Slide · deployedTHE EMERGENCY SLIDE WAS DEPLOYED ACCIDENTLY WHEN THE DOOR WAS OPENED BY THE SUPERNUMERARY AFTER SHUTDOWN. REPLACED THE ENTRY DOOR ESCAPE SLIDE PACK IAW B767 AMM 25-66-01-4. PRESSURE INDICATOR WAS IN THE GREEN BAND AND THE PIN WAS REMOVED.SDR AUS20010736Life Raft · misinstalled(AUS) DURING SERVICING OF LIFERAFT IT WAS FOUND THAT THE PACKING STRAP WAS STILL IN PLACE AROUND THE CIRCUMFERENCE OF THE RAFT. STRAP WOULD PROBABLY PREVENTED CORRECT DEPLOYMENT. LIFERAFT HAD BEEN IN SERVICE FOR APPROXIMATELY THREE YEARS. PERSONNEL/MAINTENANCESDR SWAA011973Slide · out of positionDURING SCHEDULED A1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA011972Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA011983Slide · unserviceableDURING SCHEDULED A1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA011957Wire Rope · frayedDURING SCHEDULED 1/4D CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE FRAYED AND MISROUTED. REMOVED AND REPLACED EVAC SLIDE CABLE PER MM.
Back to JASC 2565