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 DLL19002311Girt Bar · disconnectedDOOR 3L CABIN DOOR HARD TO OPEN OR CLOSE - GIRT BAR HAS TO BE MANUALLY PLACED IN RETAINER WHEN CLOSED, CORRECTIVE ACTION REATTACHED GIRT BAR IN HOOK LOCK ASSEMBLIES DOOR OPERATES NORMALLY AND ARMS DISARMS NORMALLYSDR MWEA001200Slide · detachedAFT SERVICE DOOR SLIDE FELL OUT. MAINTENANCE REINSTALLED AFT SERVICE DOOR SLIDE.SDR CA001219008Slide · deployed(CAN) DURING ARRIVAL PURSER DID NOT DISARM THE SLIDE MECHANISM ON DOOR 1L LOCATION, DOOR WAS OPEN AND THE SLIDE DEPLOY. ACTION: MAINTENANCE PERSONNEL REPLACED THE SLIDE AND RETURN THE AIRCRAFT BACK TO SERVICE.SDR SWAA002463Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND BOTH AFT EMERGENCY EVAC DOORS SLIDE PRESS IND OUT OF VIEW. ADJUSTED SLIDE ASSYS PER MM.SDR SWAA002445Slide · out of adjDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA002442Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE CAUGHT ON SIDE OF AIRCRAFT WHILE DOOR WAS BEING CLOSED & SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA002452Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA002429Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA002427Slide · out of adjC1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA002437Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER WHEN DOOR OPENED UPON ARRIVAL. RE-INSTALLED SLIDE ASSY PER MM.SDR CA001219009Tube · failed(CAN) THIS UNIT WAS SENT FOR OVERHAUL AND FAILED HYDROSTATIC TEST, AND THE INFLATABLE FAILED THE PROOF TEST, ALSO NOTICE THAT THE LOWER TUBE FAILED THE TEST AT 4 PSI AND SEPARATED ALONG THE MAIN SEAM ADJACENT TO THE PRESSURE RELEASE VALVE.SDR SWAA002422Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTANTLY FELL OUT OF CONTAINER. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002408Indicator · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY AND SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED SLIDE ASSEMBLIES PER MM.SDR SWAA002406Bracket · looseDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY BRACKETS LOOSE ON FLOOR. SECURED BRACKETS PER MM.SDR SWAA002404Cover · looseAFT SVC DOOR EMERGENCY EVAC SLIDE COVER LOOSE. SECURED SLIDE COVER PER MM.SDR CA001207008Slide · damaged(CAN) ON DESCENT DITCHING DAM DEPLOYED. RATE OF DESCENT WAS APPROXIMATELY 600 TPM. AIRCRAFT SPEED APPROXIMATELY 210 KNOTS WHEN RUMBLING NOISE NOTICED. TURBULENCE WAS SLIGHT, NO LARGE CONTROL INPUTS. MAINTENANCE FOUND DITCHING DAM FAIRING OPEN. A LEAK CHECK WASSDR USAAD00178Slide · deflatedRSW - THE TAILCONE EMERGENCY EVACUATION SLIDE FAILED TO INFLATE WHEN DEPLOYED. MAINTENANCE REPLACED THE TAILCONE EVACUATION SLIDE ASSEMBLY. (M)SDR SWAA002398Slide · unsecureAFT ENTRY DOOR SLIDE GIRT BAR STRAP NOT SECURE. SECURED PER MM.SDR SWAA002397Bottle · dischargedAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA002396Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA002381Slide · dislodgedAFT ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. RE-INSTALLED SLIDE PER MM.SDR SWAA002378Slide · out of adjAFT SVC EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. RE-ADJUSTED SLIDE ASSY PER MM.SDR SWAA002376Indicator · out of positionAFT ENTRY EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002367Indicator · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR RAAA00B2052Slide · looseFWD ENTRY ESCAPE SLIDE LOOSE ON BOTTOM. INSTALLED FWD ENTRY ESCAPE SLIDE IAW B727 M/M 25-60-6.SDR SWAA002364Slide · out of adjAFT SVC EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. REINSTALLED SLIDE ASSY PER MM.SDR SWAA002359Slide · dislodgedAFT ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. RE-INSTALLED SLIDE ASSY PER MM.SDR SWAA002356Slide · out of adjDURING LINE CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE CABLE END LOOP EXCESSIVE PER SI 11036-25. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA002343Slide · dislodgedFWD SVC DOOR EMERGENCY EVAC SLIDE FALLING OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA002357Retainer · looseDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE AFT RETAINER HOOK LOOSE. SECURED RETAINER HOOK PER MM.SDR SWAA002336Retainer · looseDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR STOWAGE RETAINER HOOKS LOOSE. SECURED HOOKS PER MM.SDR SWAA002323Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM.SDR SWAA002314Bracket · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE MOUNT BRACKET CRACKED. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA002326Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002293Indicator · out of positionBOTH EMEGRENCY EVAC SLIDE PRESS INDS OUT OF VIEW. REPOSITIONED BOTH SLIDE ASSY''S PER MM.SDR MWEA001143Slide · dislodgedAFT GALLEY DOOR ESCAPE SLIDE CAME OFF. MAINTENANCE REINSTALLED GALLEY DOOR SLIDE.SDR SWAA002289Slide · dislodgedAFT SVC EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA002291Indicator · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002277Slide · out of adjDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR GIRT ASSY OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002267Indicator · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002255Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002248Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND GIRT BAR FITTING ATTACH BRACKET CORRODED AT FWD ENTRY DOOR. REMOVED AND REPLACED GIRT BAR ATTACH BRACKET PER SRM.SDR SWAA002233Bracket · looseDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING LOOSE AT FLOOR. SECURED MOUNT BRACKET PER MM.SDR SWAA002247Indicator · out of positionDURING SCHEDULED C2 CHECK, FOUND BOTH AFT DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED SLIDE ASSY''S PER MM.SDR SWAA002230Girt Bar · out of adjDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. ADJUSTED GIRT ASSY PER MM.SDR ASAA0080655Slide · failedDURING C5 MX CHECK, FWD SERVICE DOOR EMERGENCY EVACUATION SLIDE FAILED LIGHT TEST.REPLACED SLIDE.SDR ASAA0080654Slide · failedOAK-DURING C5 MX CHECK, AFT SERVICE DOOR EMERGENCY EVACUATION SLIDE FAILED LIGHT TEST.REPLACED SLIDE.SDR SWAA002221Bracket · looseDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE COVER FWD RETAINING BRACKET RIVETS LOOSE. REPLACED RIVETS PER SRM.SDR TWAA0017202Bottle · dischargedTHE LEFT SIDE NUMBER 1 CABIN DOOR EVACUATION SLIDE BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE SLIDE ASSEMBLY. CHECK-C 6-4-00 MCI.SDR 0004095520Slide · rupturedDURING SLIDE SHOP TEST AT PERATING PRESSURE, INFLATABLE SEAM RUPTURED AT LEFT DOG LEG. SLIDE WILL BE OVERHAULED AND RECEIVE A NEW INFLATABLE.
Back to JASC 2565