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 SWAA030319Slide · out of positionDURING SCHEDULED RON, FWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA030299Bracket · looseFWD SVC DOOR EMERGENCY EVAC SLIDE ATTACH BRACKET LOOSE. SECURED BRACKET PER MM.SDR SWAA030297Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR MEX2003029Slide · stuckAIRCRAFT RETURNED TO PLATFORM, LEFT AFT SLIDE WAS NOT ARMED. ARMED AND DISARMED MECHANISM OF LEFT AFT SLIDE WAS CHECKED, IT WAS STUCK. BAR WAS REMOVED AND REINSTALLED IAW MM, TESTS CORRECT.SDR SWAA030302Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR BRACKET CORRODED. REMOVED AND REPLACED GIRT BAR BRACKET PER MM.SDR AALA20030188Slide · inoperativeDURING OVERNIGHT MAINTENANCE WHILE ACCOMPLISHING PATTERN CARD SLIDE DID NOT INFLAT DURING AUTOMATIC FUNCTION. PULLED MANUAL INFLATION HANDLE AND SLIDE STILL DID NOT INFLATE. MOVING INFLATION BOTTLE SLIDE INFLATED. REPLACED SLIDE AND INFLATION BOTTLE. SYSTESDR SWAA030291Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND BOTH FWD AND AFT SVC DOOR EMERGENCY EVAC SLIDES OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA030289Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND BOTH FWD AND AFT SVC DOOR EMERGENCY EVAC SLIDES OUT OF ADJUST. ADJUSTED BOTH SLIDES PER MM.SDR ASAA0380119Lanyard · disconnectedSEA - DURING PREFLIGHT CHECK, FOUND LEFT FORWARD (L-1) PASSENGER DOOR GIRT-TO-SLIDE COVER LANYARD DISCONNECTED. RETATTACHED LANYARD. (M)SDR GTIA030040Slide · dislodgedORD - FLT 1927 - ON TAKEOFF ROLL L2 SLIDE PACK FELL OFF. REINSTALLED L2 SLIDE PACK PER MM OK FOR SERVICE. (M)SDR SWAA030269Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030267Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030274Fitting · looseDURING SCHEDULED C3 CHECK, FOUND LOOSE RIVETS AT FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR ATTACH FITTING. REMOVED AND REPLACED ATTACH FITTING RIVETS PER SRM.SDR SWAA030273Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR ASAA0380116Lanyard · disconnectedSEA/SJD - DURING PREFLIGHT CHECK AT BOTH STATIONS, FOUND AFT LEFT (L2) SERVICE DOOR GIRT-TO-SLIDE COVER LANYARD DISCONNECTED. REATTACHED LANYARD. (M)SDR GTIA030041Slide · deployedLGA - FLT 9822 - TAILCONE SLIDE DEPLOYED UPON TRIGGERING OF THE AFT ENTRY DOOR. SLIDE REMOVED AND PLACED ON AC. REMOVED AND REPLACED TAILCONE SLIDE. (M)SDR UPS03840131Slide · deployedINSPECTION TYPE: B, WHILE ADJUSTING SIGHT GAUGE ON L1, EVAC-SLIDE INADVERTENTLY DEPLOYED SLIDE. ALL PROCEDURES WHILE ADJUSTING WERE DONE IAW MM 25-60-04. SLIDE WAS PUNCTURED ON CREW ENTRY STAIRS WHILE INFLATING. REMOVED EVAC-SLIDE FROM ACFT.SDR GTIA030036Slide · dislodgedLAS - FLT 1108 - L-2 SLIDE PACK WAS FOUND LYING ON FLOOR. REINSTALLED L-2 SLIDE PACK IAW MD80 MM 25-62-00. OPS CHECK NORMAL AT THIS TIME. (M)SDR DL76G030119Power Supply · dischargedON PDC FOUND LEFT OVERWING SLIDE SQUIB NOT ILLUMINATING WITH TEST SWITCH 1. RT SPOILER SQUIB LIGHT WILL NOT ILLUMINATE WITH TEST SWITCH 2. INSTALLED NEW BATTERY POWER SUPPLY AND BATTERY M962. ALL SQUIB TESTS NOW OK.SDR 2003UALA00129Girt Bar · inoperativeGIRT BAR AT DOOR 2L WILL NOT STAY ENGAGED DURING TAKEOFF AND LANDING. REPLACED SLIDE. SLIDE AND GIRT BAR HAVE BEEN EXAMINED BY THE SHOP. NO DEFECTS FOUND.SDR SWAA030256Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030224Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA030212Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EVACUATION SLIDE RELEASE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA030230Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDES GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR USAASA03010Girt Bar · lack of lubeLGA - THE L1 DOOR WAS DIFFICULT TO KEEP IN THE ARMED POSITION. MAINTENANCE CLEANED AND LUBRICATED THE GIRT BAR ASSEMBLY AND LOCKING MECHANISM, AND REPLACED THE L-1 DOOR EMERGENCY EVACUATION SLIDE. OK FOR SERVICE. (M)SDR USAADUPEGirt Bar · dirtyLGA - THE L1 DOOR WAS DIFFICULT TO KEEP IN THE ARMED POSITION. MAINTENANCE CLEANED AND LUBRICATED THE GIRT BAR ASSEMBLY AND LOCKING MECHANISM, AND REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE. OK FOR SERVICE. (M)SDR AMTA200300150Bottle · dischargedWHILE AT THE GATE, A PASSENGER ATTEMPTED TO OPEN L-2 DOOR WHILE ARMED. SLIDE DID NOT DEPLOY HOWEVER, IT APPEARS CO2 CHARGE DISCHARGED OR AIR BOTTLE FOR DOOR DISCHARGED. REMOVED AND REPLACED BOTTLE AS REQ'D REF MM 52-11-3 0-4. (M)SDR GTIA030048Lanyard · missingFTW - FOUND TAILCONE ESCAPE SLIDE LANYARD MISSING. INSTALLED LANYARD. (M)SDR GTIA030017Slide · dislodgedFLT 1108- LAS - L-1 DOOR SLIDE PACK FELL OFF DOOR. REINSTALLED SLIDE PACK ASSEMBLY PER MD 80 MM 25-62-00. (M)SDR SWAA030178Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR USAASA03009Slide · malfunctionedDCA - FLT 393 - EN ROUTE DCA-NAS, THE OVERWING SLIDES WERE INDICATING NOT ARMED. THE AIRCRAFT RETURNED TO GATE. MAINTENANCE ARMED THE OVERWING SLIDES. OK FOR SERVICE. (M)SDR 2003UALA00115Fitting · crackedLT DOOR 1L AFT GIRT FITTING CRACKED. REPLACED AFT GIRT FITTING.SDR SWAA030176Cable · frayedDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE RELEASE CABLE FRAYED. REMOVED AND REPLACED CABLE PER MM.SDR SWAA030164Clip · looseDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT BAR CLIP HOOK LOOSE. SECURED CLIP HOOK PER MM.SDR SWAA030157Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR DL76K030080Slide · deployedLEFT OVERWING SLIDE DEPLOYED ON ITS OWN DAMAGING SLIDE DOOR. REPLACED SLIDE, DOOR AND INFLATION CYLINDER.SDR SWAA030151Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE RELEASE CABLE MISROUTED. REROUTED SLIDE CABLE PER MM.SDR SWAA030148Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM.SDR SWAA030145Slide · looseFWD ENTRY DOOR EVACUATION SLIDE LOOSE. REINSTALLED SLIDE ASSY PER MM.SDR SWAA030143Slide · out of adjustAFT ENTRY DOOR EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM.SDR GTIA030015Slide · dislodgedFLL - FLT 9817 - PACK SLIDE FELL OFF L1 WHEN OPENED. REINSTALLED PACK SLIDE ON L1 DOOR. (M)SDR SWAA030141Hook · looseDURING SCHEDULED 1/4D CHECK, FOUND L1 DOOR ESCAPE SLIDE COVER FWD HOOK LOOSE. SECURED L1 DOOR ESCAPE SLIDE COVER FWD HOOK PER MM.SDR SWAA030135Slide · out of positionL1 DOOR ESCAPE SLIDE PARTIALLY FELL OUT OF CONTAINER. REINSTALLED THE L1 ESCAPE SLIDE PER MM.SDR SWAA030134Slide · out of positionL1 DOOR ESCAPE SLIDE PARTIALLY FELL OUT OF CONTAINER. REINSTALLED THE L1 ESCAPE SLIDE PER MM.SDR SWAA030122Slide · unserviceableL1 DOOR ESCAPE SLIDE PRESSURE IS LOW. REMOVED AND REPLACED L1 DOOR ESCAPE SLIDE PER MM.SDR SWAA030121Slide · out of adjustDURING SCHEDULED BC4 CHECK, FOUND R2 DOOR ESCAPE SLIDE OUT OF ADJUSTMENT. ADJUSTED R2 DOOR ESCAPE SLIDE PER MM.SDR AMTA200300105Ring · detachedFOUND 2L DOOR DIFFICULT TO ARM. REMOVED SURVIVAL KIT D RING FROM GIRT BAR ASSEMBLY AND REATTACHED THE VELCRO END OF THE D-RING TO THE SLIDE THIS IS ITS NORMAL STOWED POSITION. (M)SDR CNMA200300001Slide · dislodgedWHILE AT GATE FLIGHT ATTENDANT OPENED R-1 DOOR WITHOUT DISARMING DOOR. SLIDE CAME OUT OF ITS CONTAINER AND LANDED ON TOP OF CATERING TRUCK AWAITING TO DELIVER. APPARENTLY SLIDE DID NOT FALL FAR ENOUGH TO ACTIVATE DEPLOYMENT MECHANISM. SLIDE WAS REMOVED AND SDR SWAA030118Slide · out of adjustDURING SCHEDULED BC3 CHECK, FOUND THE R2 EMERGENCY ESCAPE SLIDE OUT OF ADJUSTMENT. ADJUSTED THE R2 ESCAPE SLIDE PER MM.SDR SWAA030117Lens · crazedDURING SCHEDULED BC2 CHECK, FOUND THE L1 DOOR EMERGENCY ESCAPE SLIDE LENS CRAZED. REMOVED AND REPLACED THE L1 ESCAPE SLIDE LENS PER MM.
Back to JASC 2565