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 SWAA012768Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA012766Slide · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012763Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012751Slide · out of adjFWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA012750Slide · draggingFWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. R&R SLIDE PER MM.SDR SWAA012749Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA012737Slide · unserviceableAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA012736Slide · unserviceableAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA012679Slide · out of adjDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA012680Bracket · crackedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE MOUNT BRACKET CRACKED. R&R MOUNT BRACKET PER MM.SDR SWAA012671Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA012669Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012662Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA012627Bracket · looseDURING SCHEDULED C CHECK, FOUND AFT SVC DOOR AFT FLOOR GIRT BAR BRACKET LOOSE. TIGHTENED AFT GIRT BAR BRACKET PER MM.SDR 2001FA0000332Slide · failedLT AFT SERVICE DOOR SLIDE FAILED TO FULLY INFLATE, WHILE COMPLYING WITH BOEING TASK CARD B25-61-35-C, OPERATIONAL CHECK OF ESCAPE SLIDE SYSTEMS. BOTTLE PSI WAS IN RED RANGE PRIOR TO TEST.SDR SWAA012639Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012636Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. REPOSITIONED SLIDE PER MM.SDR SWAA012633Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012626Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA012614Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR YENA200106Light · inoperativeAT JFK, R1 SLIDE FAILED EMERGENCY LIGHT TEST. REMOVED AND REPLACED SLIDE RAFT AT R1 POSITION, OPS CHECK OK IAW 25-62-44.SDR SWAA012599Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012597Bracket · looseDURING SCHEDULED C3 CHECK, FOUND R2 DOOR AFT FLOOR GIRT BAR BRACKET LOOSE. TIGHTENED AFT GIRT BAR BRACKET PER MM.SDR SWAA012596Ring · deterioratedDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE RELEASE LATCH ASSY SPLIT RING SOLDER DETERIORATED. RESOLDERED SPLIT RING PER MM.SDR SWAA012592Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND BOTH AFT DOORS EMERGENCY EVAC SLIDES PRESS IND OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA012591Slide · unserviceableDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA012579Bracket · looseDURING SCHEDULED BC4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR BRACKET LOOSE ON CONTAINER. SECURED EVAC SLIDE BRACKET PER MM.SDR SWAA012575Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. INSTALLED SLIDE PER MM.SDR SWAA012563Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012562Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012561Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA012568Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR GIRT BAR, FWD AND AFT FLOOR ATTACH BRACKETS CORRODED. REMOVED AND REPLACED ATTACH BRACKETS PER SRM.SDR SWAA012556Slide · unserviceableDURING SCHEDULED RON, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA012548Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. SECURED SLIDE PER MM.SDR UPS01836827Cover · damagedINSPECTION TYPE:IN EVAC SLIDE COVER IS DAMAGED. SLIDE CASE WILL NOT STAY CLOSED. GAPS OPEN AT THE BOTTOM. SLIDE COVER REMOVED AND ROUTED TO SHEETMETAL REPLACED SHEARED RIVETS ON COVER LATCH IAW 51-1-21 DC8 SRM 79657 9-15-01 INSTALLED SLIDE PER 25-60-01.SDR SWAA012541Cable · frayedDURING SCHEDULED 1/2D CHECK, FOUND AFT ENTRY DOOR EVAC SLIDE CABLE FRAYED. R&R EVAC SLIDE CABLE PER MM.SDR DLM88011529Slide · failedATC ORDERED AIRCRAFT TO LAND ASAP FOR SECURITY CONCERNS. RAMP PERSONNEL PULLED OUTSIDE EMERGENCY HANDLE AND DEPLOYED THE TAIL CONE. HOWEVER THE EMERGENCY SLIDE DID NOT DEPLOY. MTC INSTALLED TAIL CONE AND AIRCRAFT WAS FERRIED TO ATL. SLIDE WAS REPLACED IN ASDR SWAA012530Cable · frayedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE FRAYED. R&R CABLE PER MM.SDR SWAA012527Slide · out of positionDURING SCHEDULED BC3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012510Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR F3LA200100105Slide · dischargedDURING SERVICE CHECK, MAINTENANCE REPORTED R-1 DOOR SLIDE PRESSURE LOW. AIRCRAFT WILL BE FERRIED TO DEN FOR REPLACEMENT OF SLIDE.SDR AALA016081Cable · looseFORWARD GALLEY EXIT DOOR EMERGENCY SLIDE HAS A CABLE LOOSE ON THE GIRT BAR. RECONNECTED CABLE WIRED TO SLIDE, GOOD FOR SERVICE. (M)SDR SWAA012496Slide · looseDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR AALA016084Cable · looseFORWARD GALLEY DOOR EMERGENCY SLIDE HAS A CABLE MECHANISM LOOSE AT BOTTOM OF SLIDE. RECONNECTED GIRT BAR CABLE ASSY TO DOOR SLIDE COVER. (M)SDR AUS20010998Slide · faulty(AUS) ESCAPE SLIDE TEST LIGHTS FAILED TO ILLUMINATE DURING TEST.INSPECTION FOUND SWITCH PIN LANYARD TOO LONG.SDR SWAA012518Slide · looseDURING SCHEDULED 1/4D CHECK AT DALFORT, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE. R&R EVAC SLIDE PER MM.SDR SWAA012489Slide · out of adjAFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA012478Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012477Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA012475Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.
Back to JASC 2565