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 SWAA011958Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA011955Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED EMERGENCY EVAC SLIDE ASSY PER MM.SDR SWAA011933Slide · unserviceableDURING SCHEDULED RON CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA011922Slide · out of adjFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. ADJUSTED EMERGENCY EVAC SLIDE ASSY PER MM.SDR SWAA011921Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED EMERGENCY EVAC SLIDE PER MM.SDR ASAA0180217Lanyard · detachedPHX - DURING PREFLIGHT CHECK, R-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED FROM DOOR. REATTACHED LANYARD BETWEEN GIRT BAR AND DOOR SLIDE COVER. (M)SDR C1HA200184007Slide · unserviceableDOOR 2R EMERGENCY ESCAPE SLIDE PRESSURE GAUGE READS ZERO. REMOVED AND REPLACED R-2 DOOR SLIDE.SDR SWAA011911Cover · looseAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND VIEW COVER LOOSE. SECURED VIEW COVER PER MM.SDR MWEA011051Slide · malfunctionedEVACUATION SLIDE ON AFT SERVICE DOOR WAS INFLATED BUT DID NOT DEPLOY. AIRCRAFT FERRIED TO MILWAUKEE AND SLIDE REPLACED.SDR SWAA011901Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA011899Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND BOTH AFT DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED EVAC SLIDES PER MM.SDR SWAA011897Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. ADJUSTED EMERGENCY EVAC SLIDE PER MM.SDR ASAA0180214Lanyard · disconnectedSFO - DURING PREFLIGHT CHECK, R1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED FROM DOOR. REATTACHED LANYARD BETWEEN GIRT BAR AND DOOR SLIDE COVER. (M)SDR SWAA011935Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA011871Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA011868Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA011875Slide · unserviceableDURING SCHEDULED A1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011856Slide · out of adjAFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. RE-ADJUSTED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011879Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA011854Slide · deployedAFTER FERRY FLIGHT TO HOU, FWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011861Slide · unserviceableDURING SCHEDULED RON CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR 0102209988Slide · unserviceableDURING LINE CHECK, DISCOVERED TAIL EVACUATION SLIDE PRESSURE AT ZERO PSI. REPLACED SLIDE AND RETURNED REMOVED SLIDE TO SHOP FOR REPAIR.SDR AUS20010706Cable · frayed(AUS) FORWARD GALLEY DOOR ESCAPE SLIDE RELEASE CABLE FRAYED. FOUNDDURING INSPECTION IAW AD/B737/042.SDR SWAA011838Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011828Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011827Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011826Slide · out of positionAFT DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011829Slide · deployedAFT SVC DOOR EMERGENCY EVAC SLIDE DEPLOYED ON GROUND. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR ASAA0180208Slide · unserviceableSFO - DURING PREFLIGHT CHECK, FOUND L2 DOOR EMERGENCY SLIDE INFLATION PRESSURE LOW. REPLACED L2 DOOR SLIDE PER MM 25-62-00. (M)SDR UPS01836166Slide · out of positionINSPECTION TYPE:N/A DEPARTURE-ESCAPE SLIDE GIRT BAR WOULD NOT LOCK IN PLACE. *S/D* REPACKED SLIDE, OPS CHECKS GOOD REF M217781.SDR 2001UALA01195Slide · failedSLIDE FAILED AIR RETENTION TEST DURING OVERHAUL.SDR SWAA011798Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR DHL2001364020Warning System · failedSLIDE ALARM ON RT DOOR DOES NOT SOUND WHEN TESTED. SLIDE ALARM OPS CHECKS NORMAL IAW MM REF 52-70-00.SDR SWAA011772Bracket · crackedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE FWD ATTACH BRACKET CRACKED. R&R EMERGENCY EVAC SLIDE ATTACH BRACKET PER MM.SDR SWAA011734Retainer · looseDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINER LOOSE. R&R RIVET PER MM.SDR C1HA200193010Slide · out of positionESCAPE SLIDE CAME OUT OF CASING ON L-1 DOOR DURING FLIGHT. REINSTALLED SLIDE PER MM.SDR SWAA011741Slide · out of adjDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. ADJUSTED SLIDE ASSY PER MM.SDR SWAA011728Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011717Wire · exposedDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE HAS EXPOSED WIRES. SECURED EMERGENCY EVAC SLIDE WIRES PER MM.SDR SWAA011725Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. ADJUSTED EMERGENCY EVAC SLIDE GIRT ASSY PER MM.SDR P5CA0100569Slide · defectiveRT UPPER DECK SLIDE BLOWN BY MAINTENANCE AND ONLY HALF INFLATED. REPLACED U/D RIGHT SLIDE ASSIST BOTTLE. REMOVED AND REPLACED U/D RIGHT SLIDE FOUND SHEARED CABLE. P/N ON 7A1248-36 S/N ON G476.SDR SWAA011705Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011689Retainer · looseFED ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK LOOSE. SECURED GIRT BAR HOOK PER MM.SDR SWAA011672Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. INSTALLED EMERGENCY EVAC SLIDE PER MM.SDR 2001UALA01194Slide · failedSLIDE RAFT FAILED AIR RETENTION TEST DURING OVERHAUL.SDR SWAA011671Bracket · brokenAFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR LATCH BROKEN. R&R AFT SVC DOOR GIRT BAR LATCH PER MM.SDR SWAA011669Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011668Slide · out of positionDURING SCHEDULED BC1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA011651Slide · unserviceableDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. Removed and replaced EMERGENCY EVAC SLIDE PER MM.SDR UPS01836018Container · damagedINSPECTION TYPE:N/A DEPARTURE, ESCAPE SLIDE FELL OUT WHEN FWD ENTRY DOOR CLOSED. DEFERRED SLIDE CONTAINER DUE TO DAMAGE.
Back to JASC 2565