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 0004085508Slide · rupturedDURING SLIDE SHOP TEST AT OPERATING PRESSURE, INFLATABLE FAILED AT LOWER TUBE OPPOSITE GIRT BAR. SLIDE WILL BE OVERHAULED AND RECEIVE A NEW INFLATABLE.SDR SWAA002196Retainer · looseDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR GIRT BAR FWD ATTACH HOOK LOOSE. REMOVED AND REPLACED RIVETS PER SRM.SDR ASAA0080652Lanyard · looseBUR - PRIOR TO DEPARTURE, R-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE IMPROPERLY ATTACHED TO SLIDE. SECURED LANYARD PROPERLY. (M)SDR UIEA00050Slide · deployedDURING SAMPLE SLIDE DEPLOYMENT, AFTER DEPLOYING UPPER DECK CREW SLIDE FROM DOOR, SLIDE DID NOT AUTOMATICALLY INFLATE. SLIDE DID INFLATE AFTER THE MANUAL INFLATION HANDLE WAS PULLED. ACCOMPLISHED INSPECTION AND RIGGING CHECKS OF FAILED SLIDE PER TESTS 25-68-0SDR SWAA002190Slide · looseDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR GIRT ASSY PLAYOUT EXCESSIVE. ADJUSTED SLIDE ASSY PER MM.SDR SWAA002198Slide · dislodgedFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. SECURED SLIDE ASSY PER MM.SDR SWAA002197Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002191Slide · looseDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR GIRT ASSY PLAYOUT EXCESSIVE. ADJUSTED SLIDE ASSY PER MM.SDR SWAA002189Slide · dislodgedDURING SCHEDULED RON , FOUND FWD SVC DOOR GIRT BAR FELL FROM SLIDE COVER UPON DOOR OPERATION. RE-STOWED GIRT BAR PER MM.SDR SWAA002188Indicator · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR MWEA001111Slide · dislodgedEMERGENCY SLIDE FELL OFF FORWARD ENTRANCE DOOR WHEN CLOSING. MTC REINSTALLED COVER AND SLIDE.SDR USAAF00076Slide · inoperativeGSO - FOUND THE FORWARD GALLEY SERVICE DOOR EMERGENCY EVACUATION SLIDE HAD LOW PRESSURE. MAINTENANCE REPLACED THE FORWARD GALLEY SERVICE DOOR EMERGENCY EVACUATION SLIDE. OK FOR SERVICE. (M)SDR ASAA0080651Lanyard · looseOAK DURING MAINTENANCE CHECK FOUND R1 DOOR EMERGENCY SLIDE LANYARD LATCH PIN, P/N 3961896, LOOSE (COULD BE PUSHED OUT BY HAND). LANYARD ASSEMBLY HAD BEEN PREVIOUSLY MODIFIED PER AD 2000-8-18 AMDT 39-11704. REPLACED ENTIRE LANYARD ASSEMBLY.SDR SWAA002157Slide · deployedAFT SERVICE DOOR EMERGENCY EVAC SLIDE DEPLOYED. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR UPS00834259Slide · inoperativeINSPECTION TYPE:N/A, ESCAPE SLIDE WILL NOT ARM. ATTACHED GIRT BAR.SDR MWEA001069Slide · dislodgedPAX DOOR EVAC SLIDE IS REMOVED FROM DOOR AND LAYING IN ENTRYWAY. MAINTENANCE REINSTALLED FORWARD PAX DOOR EVACUATION SLIDE.SDR SWAA002142Girt Bar · out of adjDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. ADJUSTED SLIDE ASSY PER MM.SDR SWAA002140Girt Bar · out of adjDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. RE-ADJUSTED SLIDE ASSY PER MM.SDR SWAA002137Indicator · out of positionAFT ENTRY EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002136Slide · dislodgedDURING FWD ENTRY DOOR CLOSURE, GIRT BAR WAS SNAGGED AND INADVERTANTLY PULLED EVAC SLIDE OUT OF CASE. REINSTALLED SLIDE PER MM.SDR CA001123019Cover · missing(CAN) DITCHING DAM COVER DETACHED, DAM SEPARATED INFLT. A/C JUST LEVELLED IN CRUISE, CABIN CREW RPTED LOAD BANGING NOISE, SPEED REDUCED, 1ST OFFICER INSP&CONFIRMED DAM COVER DETACHED, BUT DAM STILL ATTACHED. PAN DECLARED, INITY ELECTED TO DIVERT OT NEWQUAY TO SDR USAAD00168Bottle · dischargedIND - THE TAILCONE EVACUATION SLIDE INFLATION PRESSURE BOTTLE PRESSURE WAS LOW. THE AIRCRAFT WAS FERRIED TO THE MAINTENANCE BASE AND THE TAILCONE EVACUATION SLIDE ASSEMBLY WAS REPLACED. (M)SDR SWAA002123Bracket · looseDURING SCHEDULED C4 CHECK, FOUND FWD SERVICE DOOR FWD GIRT BAR BRACKET LOOSE ON FLOOR. SECURED BRACKET PER MM.SDR USAASA00041Connector · failedDCA - THE AFT LEFT DOOR EMERGENCY ESCAPE SLIDE FAILED THE EPSU TEST. MAINTENANCE RESEATED A PIN IN THE CANNON PLUG FOR THE AFT LEFT DOOR EMERGENCY ESCAPE SLIDE. SYSTEM OK FOR SERVICE. (M)SDR ASAA0080644Lanyard · disconnectedPDX-PRIOR TO FLIGHT, R-1 DOOR EMERGENCY SLIDE LANYARD DETERMINED TO BE DISCONNECTED. RECONNECTED LANYARD.SDR SWAA002113Bottle · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE DOOR EMERGENCY EVAC SLIDE PRESS IND LOW. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA002110Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CASE WHILE PARKED AT GATE. REINSTALLED SLIDE ASSY PER MM.SDR SWAA002105Bracket · looseDURING SCHEDULED C4 CHECK, FOUND AFT SERVICE DOOR GIRT BAR HOLD DOWN BRACKET LOOSE IN FLOOR. SECURED BRACKET PER MM.SDR SWAA002089Slide · dislodgedDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY SAGGING. ADJUSTED SLIDE ASSY PER MM.SDR SWAA002086Bracket · corrodedDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOOR GIRT BAR AFT BRACKET FLOOR FITTING CORRODED. REMOVED AND REPLACED CORRODED GIRT BAR BRACKET FITTING.SDR SWAA002111Slide · dislodgedDURING FWD ENTRY DOOR CLOSURE, EMERGENCY EVAC SLIDE ENGAGED FRAME AND FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA002098Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CASE. REINSTALLED SLIDE ASSY PER MM.SDR SWAA002094Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR GIRT BAR CABLE MISROUTED. RE-ROUTED CABLE ASSY PER MM.SDR SWAA002091Slide · dislodgedFWD ENTRY EMERGENCY EVAC SLIDE CAME OUT OF CONTAINER. REINSTALLED FWD ENTRY DOOR SLIDE PER MM.SDR SWAA002078Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE CAME LOOSE FROM DOOR. RE-INSTALLED SLIDE ASSY PER MM.SDR SWAA002071Bottle · dischargedFWD ENTRY EMERGENCY EVAC SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA002053Bracket · brokenFWD ENTRY DOOR EMERGENCY EVAC SLIDE BRACKET BROKEN. REMOVED AND REPLACED BRACKET ASSY PER MM.SDR SWAA002070Slide · dislodgedAFT SVC DOOR EMERGENCY EVAC SLIDE FALLING OUT OF CASE. REINSTALLED SLIDE ASSY PER MM.SDR SWAA002061Cover · looseDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE LATCH WOULD NOT ENGAGE COVER RETAINER CORRECTLY. REPOSITIONED COVER PER MM.SDR SWAA002056Indicator · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC AND ENTRY DOOR SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED SLIDE ASSEMBLIES PER MM.SDR DL76S002047Bottle · dischargedON LAYOVER FOUND RT WING OVERWING SLIDE BOTTLE PRESS LOW. REPLACED BOTTLE.SDR AU001100Cylinder · unapproved part(AUS) LH OVERWING SLIDE INFLATION CYLINDER INCORRECT PART. THE INCORRECT PNO 130104-223 INFLATION CYLINDER HAS A 750 CUBIC INCHCAPACITY BOTTLE WHILE THE CORRECT INFLATION CYLINDER HAS A 900 CUBIC INCH CAPACITY BOTTLE. UNAPPROVED PART.SDR SWAA002045Indicator · out of positionAFT ENTRY EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002042Indicator · out of positionDURING SCHEDULED C2 CHECK, FOUND EMERGENCY ESCAPE SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR AALA006142Slide · dislodgedSNA - AFT GALLEY SLIDE PACKAGE FELL OUT. REINSTALLED SLIDE ASSY, CHECKS OK. (M)SDR DLM88002005Cover · brokenWHEN OPENING L1 DOOR, THE SLIDE ASSY FELL OFF OF THE DOOR AND ON TO THE RAMP. THE SLIDE WAS NOT ARMED AND DID NOT DEPLOY. THE SLIDE''S PLASTIC COVER WAS DAMAGED SO IT WAS REPLACED. S/N OFF 0382, S/N ON 1145, P/N 259001365.SDR DLM88001998Slide · damagedDOOR 1R GIRT BAR DAMAGED. FOUND SLIDE PACK COMING APART. REPLACED SLIDE PACK ASSY.SDR SWAA002008Retainer · looseDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY EMERGRENCY EVAC SLIDE COVER AFT GIRT BAR RETAINER LOOSE. SECURED GIRT BAR RETAINER PER MM.SDR SWAA002001Bottle · dischargedDURING SCHEDULED RON CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA002000Indicator · out of positionAFT EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. ADJUSTED SLIDE ASSY PER MM.
Back to JASC 2565