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 SWAA030731Cable · misroutedDURING SCHEDULED C 2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA030718Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030725Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER WHEN OPENING DOOR. REINSTALLED SLIDE PER MM.SDR SWAA030720Lens · looseDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE VIEWING WINDOW LENS LOOSE. SECURED LENS PER MM.SDR AWXA200300363Fitting · corrodedLCQ - EES - DURING C-18 CHECK CORROSION WAS FOUND ON THE L-1 DOOR AFT GIRT BAR ATTACH FITTING BS 344. MAINTENANCE REMOVED AND REPLACED THE L-1 DOOR AFT GIRT BAR LOCK AND ATTACH FITTINGS. PART NAME; LOCK, MFG; BOEING, P/N; 65-65972-3.SDR SWAA030704Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030689Slide · unserviceableAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR CALA0300149Actuator · inoperativeTHE FORWARD AND AFT DOOR ACTUATORS FOR THE RT SIDE OFF-WING SLIDE DOOR WERE FOUND EXPENDED. THE DOOR ACTUATORS WERE REMOVED AND REPLACED IAW MM 25-65-10.SDR SWAA030695Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA030693Slide · 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 SWAA030690Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA030680Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA030660Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030653Bracket · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE RETAINING BRACKET OUT OF ADJUST. ADJUSTED BRACKET PER MM.SDR SWAA030642Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA030639Slide · deployedAFT ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED WHEN OPENING THE DOOR. MX FERRY TO MCO, REMOVED AND REPLACED SLIDE PER MM.SDR SWAA030648Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE AT MOUNT. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA030631Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR AUS20030382Slide · faulty(AUS) ESCAPE SLIDE FAULTY. SLIDE DEPLOYED AND INFLATED CORRECTLY BUT FAILED TO DROP TO THE GROUND. THE RAFT WAS TWISTED APPROXIMATELY 45 DEGREES AROUND THE LONG AXIS WITH THE INBOARD END IN CONTACT WITH THE OUTSIDE OF THE DOOR FRAME/FUSELAGE.SDR ASAA0380265Slide · failedOAK - FOUND DURING 15K CHECK, AFT PASSENGER DOOR EMERGENCY SLIDE FAILED LIGHT CHECK. REPLACED EMERGENCY SLIDE PER TASK CARD 24655000. (M)SDR ASAA0380271Lanyard · disconnectedSEA - DURING LINE CHECK, FORWARD LEFT L1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD PER MM 25-62-00. (M)SDR ASAA0380269Slide · failedOAK - DURING 15K CHECK, FOUND FORWARD PASSENGER L1 DOOR EMERGENCY SLIDE FAILED LIGHT CHECK. REPLACED EMERGENCY SLIDE PER TASK CARD 24655000. (M)SDR GTIA030163Slide · dislodgedRIGHT 1 SLIDE PACK CAME OFF WHEN DOOR WAS OPENED AND LOCKED BACK DIFFICULT TO LOCK BACK. INSTALLED NEW SLIDE PACK RT 1 DOOR. NO OTHER DEFECTS NOTED. DOOR OPEN LATCH OPS CHECK GOOD.SDR SWAA030611Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA030610Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER WHEN OPENING THE DOOR. REINSTALLED SLIDE PER MM.SDR SWAA030604Fitting · looseDURING SCHEDULED 1/4D CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD ATTACH FITTING LOOSE. R&R FASTENERS PER SRM.SDR SWAA030597Fitting · looseDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD ATTACH FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA030593Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA030594Fitting · looseDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR AFT ATTACH FITTING LOOSE. SECURED AFT ATTACH FITTING PER MM.SDR SWAA030592Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030582Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER WHEN CLOSING DOOR. REINSTALLED SLIDE PER MM.SDR SWAA030581Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA030596Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR DL76S030239Lanyard · separatedDOOR DIFFICULT TO ARM/DISARM. SLIDE PACK FELL OUT WHILE DOOR WAS OPENING (2R). INSTALLED NEW SLIDE, OPS NORMAL.SDR SWAA030578Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA030567Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA030563Fitting · looseDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD ATTACH FITTING LOOSE. SECURED ATTACH FITTING PER MM,SDR SWAA030562Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED BOTH FWD CABIN DOOR SLIDES PER MM.SDR SWAA030551Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR UPS03840269Slide · inoperativeLOOK AT ESCAPE SLIDE CONTAINER PARTIALLY OPEN. REPACKED AND RESECURED ESCAPE SLIDE AS REQ, A/C OK TO CONTINUE.SDR SWAA030533Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030537Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE LIGHTS INOP. REMOVED AND REPLACED BATTERIES PER MM.SDR SWAA030547Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA030545Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA030543Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030542Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR CALA0300106Light · inoperativeTHE TAILCONE SLIDE LIGHT FAILED BATTERY TEST. THE SLIDE ASSEMBLY WAS REMOVED AND REPLACED IAW MM 25-62-01.SDR GTIA030136Slide · inoperativeL1 SLIDE PRESS IN RED BAND. REMOVED AND REPLACED L-1 SLIDE EVAC.SDR USAABB03069Light · inoperativePHL - DURING AN ANNUAL SLIDE DEPLOYMENT CHECK, THE R1 DOOR SLIDE WAS DEPLOYED AND INFLATED NORMALLY. HOWEVER, NONE OF THE LIGHTS OPERATED. THE SLIDE WAS REPLACED. THE SHOP CONCLUDED THAT THE SLIDE FUNCTIONED PROPERLY, BUT THAT THE BATTERY WAS DEAD. (M)SDR SWAA030512Girt Bar · out of adjustBOTH AFT CABIN DOOR EVACUATION SLIDE GIRT BARS WOULD NOT GO IN BRACKETS. REMOVED AND REPLACED BOTH EVACUATION SLIDE ASSY'S PER MM.
Back to JASC 2565