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 AALA20030762Spring · out of adjustDURING ACCOMPLISHMENT OF ENGINEERING REQUEST OT CHECK GIRT BAR SPRINGS TO EACH PASSENGER DOOR POSITION, FOUR GIRT BAR SPRINGS OUT OF ADJUSTMENT. ADJUSTED FOUR GIRT BAR SPRINGS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030754Spring · out of adjustDURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, EIGHT GIRT BAR SPRINGS OUT OF ADJUSTMENT. ADJUSTED EIGHT GIRT BAR SPRINGS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SWAA031516Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINING BRACKETS CORRODED. REMOVED AND REPLACED GIRT BAR RETAINING BRACKETS PER SRM.SDR ASAA0380535Slide · disconnectedPREFLIGHT CHECK, FORWARD SERVICE R-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND INOPERATIVE, DISCONNECTED. 'RESET' RECONNECTED LANYARD. (M)SDR AALA20030768Spring · damagedDURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, TWO GIRT BAR SPRINGS NEEDING REPLACED. REPLACED TWO GIRT BAR SPRINGS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030766Spring · damagedDURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, ONE GIRT BAR SPRING NEEDING REPLACED. REPLACE ONE GIRT BAR SPRING. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030761Spring · out of adjustDURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, ONE GIRT BAR SPRING OUT OF ADJUSTMENT. ADJUSTED ONE GIRT BAR SPRING. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030760Spring · out of adjustDURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, TWO GIRT BAR SPRINGS OUT OF ADJUSTMENT. ADJUSTED TWO GIRT BAR SPRINGS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030745Girt Bar · stuckUPON ARRIVAL BOS FROM MIA, L1 DOOR STUCK IN ARMED MODE. REMOVED BURRS AND NICKS FROM GIRT BAR ENGAGEMENT SLIDES. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030751Spring · out of adjustJFK - DURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, ONE GIRT BAR SPRING OUT OF ADJUSTMENT. ADJUSTED ONE GIRT BAR SPRING. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030748Spring · out of adjustDURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, FOUR GIRT BAR SPRINGS OUT OF ADJUSTMENT. ADJUSTED FOUR GIRT BAR SPRINGS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SWAA031514Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR AALA20030763Spring · damagedDFW - DURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, FOUR GIRT BAR SPRINGS NEEDING REPLACED. REPLACED FOUR GIRT BAR SPRINGS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030755Spring · out of adjustDURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, THREE GIRT BAR SPRINGS OUT OF ADJUSTMENT AND ONE NEEDING REPLACED. ADJUSTED THREE GIRT BAR SPRINGS AND REPLACED ONE. SYSTEM GROUND CHECKED NORMAL OPERATIOSDR SWAA031505Indicator · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031504Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR ASAA0380530Lanyard · disconnectedPDX - PREFLIGHT CHECK, FORWARD PAX (L-1) DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR AALA20030772Spring · damagedDURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, FOUR GIRT BAR SPRINGS NEEDING REPLACED. REPLACED FOUR GIRT BAR SPRINGS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030770Spring · damagedDURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, FOUR GIRT BAR SPRINGS NEEDING REPLACED. REPLACED FOUR GIRT BAR SPRINGS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SWAA031485Indicator · out of positionDURING SCHEDULED PM CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031506Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR MWEA030271Slide · damagedFORWARD GALLEY DOOR SLIDE WAS KNOCKED OFF DOOR. CAGE AROUND THE GAUGE WAS DAMAGED. REMOVED AND REPLACED FORWARD GALLEY DOOR SLIDE.SDR SWAA031491Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA031490Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA031474Indicator · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR AALA20030752Spring · out of adjustDURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, TWO GIRT BAR SPRINGS OUT OF ADJUSTMENT. ADJUSTED TWO GIRT BAR SPRINGS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR 2003UALA00543O-Ring · leakingUPON ARRIVAL FOUND BOTTLE PRESSURE ON SLIDE AT DOOR 1R BELOW THE GREEN BAND. LEAKING O-RING BETWEEN RESERVOIR AND VALVE/REGULATOR CAUSED REDUCED BOTTLE PRESSURE. REPLACED SLIDE BOTTLE, INSPECTED/TESTED REMOVED BOTTLE TO DETERMINE CAUSE, THEN OVERHAULED VALVSDR SWAA031473Slide · dislodgedL1 DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR AALA20030813Spring · damagedDURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, ONE GIRT BAR SPRING OUT OF ADJUSTMENT. ADJUSTED ONE GIRT BAR SPRING. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030765Spring · damagedDFW - DURING ACCOMPLISHMENT OF ENGINEERING REQUEST OT CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, FOUR GIRT BAR SPRINGS NEEDING REPLACED. REPLACED GIRT BAR SPRINGS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030753Spring · out of adjustDURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, TWELVE GIRT BAR SPRINGS OUT OF ADJUSTMENT. ADJUSTED TWELVE GIRT BAR SPRINGS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AUS20030667Slide · deflated(AUS) NR 3 RT DOOR ESCAPE SLIDE DEFLATED DURING EMERGENCY EVACUATION OF AIRCRAFT FOLLOWING BRAKE FIRE.SDR SWAA031454Slide · looseDURING SCHEDULED PM CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR HEEA088082Handle · brokenSLIDE HANDLE HAS BROKEN PIN. REPLACED.SDR AALA20030750Spring · out of adjustDURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, TWELVE GIRT BAR SPRINGS OUT OF ADJUSTMENT. ADJUSTED TWELVE GIRT BAR SPRINGS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SWAA031460Girt Bar · looseDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOKS LOOSE. REMOVED AND REPLACED HOOK FASTENERS PER SRM.SDR AALA20030715Spring · out of adjustDURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, FOUND THE R4 DOOR GIRT BAR LEAF SPRINGS NOT WORKING PROPERLY. REPLACED GIRT BAR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030714Spring · out of adjustDURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION, FOUND THE L2 DOOR GIRT BAR LEAK SPRINGS NOT WORKING PROPERLY. REPLACED GIRT BAR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030713Girt Bar · damagedDURING ACCOMPLISHMENT OF ENGINEERING REQUEST TO CHECK GIRT BAR SPRINGS AT EACH PASSENGER DOOR POSITION. FOUND THE R1 DOOR GIRT BAR LEAF SPRINGS NOT WORKING PROPERLY. REPLACED GIRT BAR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR EA332003B0977Locking Plate · bentDURING AN OPERATIONAL CHECK OF THE INFLATABLE EVACUATION SYSTEM AT THE RT UPPER DECK DOOR ACCORDING MS 23-66-00-040-100 THE RESERVOIR WAS NOT ACTIVATED AND THE SLIDE DID NOT INFLATE. FURTHER INVESTIGATION REVEALED THAT THE PACKBOARD LOCKING PLATE WAS RELEASEDSDR UIEA200300028Slide · failedDURING C-04 CHECK IN FRA, A TEST OF THE UPPER DECK RIGHT ESCAPE SLIDE WAS TO BE PERFORMED. DURING PREPARATION A NOTE WAS MADE TO A DEFECT WITH A PACKBOARD LOCKING PLATE & 4 RETAINING SCREWS BEING LOOSE & LOCKING PLATE BEING BENT & OUT OF POSITION. AS A PRECASDR SWAA031451Girt Bar · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031440Hook · looseDURING SCHEDULED C3 CHECK, FOUND LOOSE RIVETS AT FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINER HOOK. REMOVED AND REPLACED RETAINER HOOK RIVETS PER SRM.SDR SWAA031439Indicator · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATOR OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031445Indicator · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR C1HA200394011Slide · dislodgedSLIDE FELL OUT OF R-1 DOOR.SDR SWAA031446Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR ASAA0380512Lanyard · disconnectedPREFLIGHT CHECK, FORWARD RIGHT SERVICE (R-1) DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR SWAA031424Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA031423Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.
Back to JASC 2565