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 SWAA040664Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND BOTH L2 AND R2 DOOR EVACUATION SLIDES OUT OF ADJUST. REPOSITIONED BOTH SLIDE ASSY'S PER MM.SDR SWAA040653Slide · out of positionR2 DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA040649Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040669Slide · out of adjustR1 DOOR EVACUATION SLIDE OUT OF ADJUST. REPOSITIONED SLIDE PER MM.SDR 2004UALA00286Slide · failedDOOR 2 RIGHT SLIDE FAILED OVER PRESSURE TEST AT 3.80 PSI DURING OVERHAUL. SLIDE OEM ANALYSIS OF FAILURE WAS INCONCLUSIVE. INFLATABLE PORTION OF SLIDE SCRAPPED.SDR SWAA040645Slide · out of adjustDURING SCHEDULED D CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA040644Slide · out of adjustL2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR GTIA040150Cable · disconnectedORD - FLT 1103 - FOUND CABLE ON SLIDE PACK NOT ATTACHED, R1 DOOR SLIDE PACK FELL OFF. REINSTALLED SLIDE PACK FOR R1 DOOR. INSTALLED SLIDE PACK CABLE. (M)SDR MALA040225Handle · misroutedMAIN PAX DOOR SLIDE PULL HANDLE ON EMERGENCY SLIDE NOT ROUTED CORRECTLY. REMOVED SLIDE PACK & RE-ROUTED SLIDE FLAP AS REQ'D FOR PROPER OPERATION & INSTALLATION.SDR SWAA040611Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040610Slide · out of adjustDURING SCHEDULED A2 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA040605Slide · out of adjustDURING SCHEDULED PM CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040602Slide · dislodgedDURING SCHEDULED RON CHECK, FOUND L1 DOOR EVAC SLIDE INADVERTANTLY PULLED FROM DOOR. REINSTALLED L1 DOOR EVAC SLIDE PER MM.SDR UPS04141966Warning Horn · malfunctionedINSPECTION TYPE:N/A LEVEL AT FL330 THE SLIDE WARNING HORN BUZZED CONTINUOUSLY. RESET C/B SLIDE WARNING HORN, CHECKS NORMAL.SDR UPS04141964Girt Bar · stiffENTRY DOOR ESCAPE SLIDE HANDLE IS DIFFICULT TO MOVE TO THE DISARM POSITION. ROUGH FEEL CHECK IAW MM 25-61-20-2. GIRT BAR CLEANED AND LUBRICATED, SATISFACTORY.SDR USAABB04027Slide · deployedPIT - DURING AN ANNUAL SLIDE OPERATIONAL CHECK, THE R1 DOOR SLIDE DEPLOYED PROPERLY, BUT FAILED TO HOLD PRESSURE. MAINTENANCE REPLACED THE SLIDE. THE SLIDE WAS FOUND TO HAVE NUMEROUS HOLES. THE HOLES WERE REPAIRED AND THE SLIDE RETURNED TO SERVICE. (M)SDR USA2004F00016Slide · leakingDURING ANNUAL SLIDE OPERATIONAL CHECK, THE R1 DOOR SLIDE DEPLOYED PROPERLY, BUT FAILED TO HOLD PRESSURE. MAINTENANCE ACTION PENDING.SDR USA2004F00006Slide · deflatedDURING THE OPERATIONAL CHECK OF THE RIGHT FRONT PASSENGER DOOR SLIDE, THE SLIDE DEPLOYED BUT DID NOT HOLD PRESSURE. THE LOWER SUPPORT CHAMBERS DID NOT RECEIVE ENOUGH PRESSURE, AND THE ENTIRE SLIDE HAD LOST MOST OF ITS PRESSURE WITHIN FIVE MINUTES OF BEING DEPSDR SWAA040575Slide · out of adjustDURING SCHEDULED SERVICE CHECK, FOUND R1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040569Slide · dislodgedL1 DOOR EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED THE L1 DOOR EVAC SLIDE INTO CONTAINER PER MM.SDR AALA20040307Slide · damagedTUL - EVACUATION SLIDE AT RIGHT HAND FORWARD SERVICE DOOR, STATION 312, FAILED TO STAY INFLATED DUE TO A HOLE IN THE SLIDE. REPLACED SLIDE AT FORWARD SERVICE DOOR PER WORKCARD 8814. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR SWAA040568Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA040565Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040557Slide · out of adjustL1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR SWAA040556Slide · unserviceableR2 DOOR EVAC SLIDE LOW PRESSURE INDICATION. REMOVED AND REPLACED R2 DOOR EVAC SLIDE PER MM.SDR AALA20040284Slide · failedMIA - EMERGENCY ESCAPE SLIDE AT DOOR 1L FELL OFF ITS HOLDER AND DID NOT DEPLOY WHEN ARMED DOOR WAS OPENED. POWER ASSIST BOTTLE WAS BLOWN. JETBRIDGE WAS ATTACHED. REPLACED POWER ASSIST BOTTLE AND INSTALLED NEW SLIDE AT 1L DOOR. SYSTEM GROUND CHECKED NORMAL SDR SWAA040571Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040547Slide · out of positionR2 DOOR EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED THE R2 DOOR EVAC SLIDE INTO CONTAINER PER MM.SDR MWEA040020Bottle · lowAFT ACCESS EVACUATION SLIDE PRESSURE BELOW 2000 PSI. REMOVED AND REPLACED AFT EVACUATION SLIDE.SDR MWEA040019Girt Bar · bentTHE GIRT BAR AT THE FORWARD SERVICE DOOR WILL NOT STAY IN IT'S HOLDER. FOUND HOLDER BENT, ADJUSTED HOLDER.SDR SWAA040542Slide · deployedR2 DOOR EVAC SLIDE DEPLOYED WHEN DOOR WAS OPENED. REMOVED AND REPLACED R2 DOOR EVAC SLIDE PER MM.SDR MWEA040023Pin · inoperativeAFT SERVICE DOOR ESCAPE SLIDE PIN WILL NOT STAY IN POSITION. INSTALLED SLIDE COVER.SDR GTIA040139Slide · out of positionLAS - FLT 1874 - L1 DOOR SLIDE PACK FELL OFF. REINSTALLED L1 DOOR SLIDE PACK. (M)SDR SWAA040539Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR SWAA040538Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR GTIA040153Lanyard · misinstalledFLL - R1 DOOR ESCAPE SLIDE LANYARD INSTALLED INCORRECTLY. ROUTED LANYARD CORRECTLY. (M)SDR SWAA040521Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR ASAA0480075Lanyard · disconnectedSEA - FOUND FORWARD PAX L1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR SWAA040515Slide · out of adjustDURING SCHEDULED A2 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040498Slide · looseL1 DOOR EVAC SLIDE LOOSE. SECURED L1 DOOR EVAC SLIDE PER MM.SDR SWAA040493Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA040488Slide · unserviceableL1 DOOR EVAC SLIDE LOW PRESSURE INDICATION. REMOVED AND REPLACED L1 DOOR EVAC SLIDE PER MM.SDR SWAA040487Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040477Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040471Slide · dischargedL2 DOOR EVAC SLIDE LOW PRESSURE INDICATION. REMOVED AND REPLACED L2 DOOR EVAC SLIDE PER MM.SDR SWAA040463Slide · dischargedDURING SCHEDULED MV1 CHECK, FOUND R2 DOOR EVAC SLIDE LOW PRESSURE INDICATION. REMOVED AND REPLACED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040454Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA040445Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040439Slide · out of adjustDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA040437Slide · deployedL1 DOOR EVAC SLIDE DEPLOYED AT GATE. REMOVED AND REPLACED L1 DOOR EVAC SLIDE PER MM.
Back to JASC 2565