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 SWAA002733Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. READJUSTED SLIDE ASSY PER MM.SDR SWAA002722Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE ASSY OUT OF POSITION. REPOSITIONED EVAC SLIDE ASSY.SDR SWAA002737Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. READJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA002724Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED AT JETWAY. R&R EVAC SLIDE ASSY PER MM.SDR SWAA002720Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SVC & AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS INDS OUT OF VIEW. ADJUSTED SLIDE ASSY PER MM.SDR SWAA002699Slide · out of positionR2 DOOR EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002688Slide · unserviceableDURING SCHEDULED LINE CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS LOW. R&R EVAC SLIDE ASSY PER MM.SDR SWAA002679Slide · out of positionDURING SCHEDULED SERVICE CHECK, FOUND BOTH AFT DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW AND GIRT ASSY'S SAGGING. REPOSITIONED EVAC SLIDE ASSY'S PER MM.SDR SWAA002678Slide · out of positionDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY SAGGING. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR 2000UALA00797Service difficultyDOOR 1L OPENED WITH SLIDE ARMED, DOOR STOPPED LESS THAN HALF WAY OPEN. CHAINS ON BOTTOM OF SLIDE RESTRAINED DOOR FROM OPENING FURTHER.SDR SWAA002687Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE ASSY PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002671Lens · damagedDURING SCHEDULED D CHECK, FOUND ALL FOUR EMERGENCY EVAC SLIDE PRESS INDICATORS DIFFICULT TO READ. REPAIRED VIEW PLATES PER MM.SDR 2000UALA00796Battery Pack · inoperativeESCAPE SLIDE PRESSURE WARNING LIGHT CAME ON AT 4R. *S/D* THE ESCAPE SLIDE PRESSURE WARNING LIGHT WAS FALSELY ILLUMINATED DUE TO CORROSION ON REMOTE PRESSURE INDICATOR BATTERY PACK. A VISUAL INSPECTION OF THE BATTERY PACK CONFIRMED THE PRESENCE OF CORROSION SDR SWAA002667Slide · out of positionAFT SVC & AFT ENTRY DOOR EMERGENCY EVAC SLIDE ASSY PRESS INDICATORS OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002663Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE ASSY FELL OUT OF CONTAINER REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA002673Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002665Slide · unserviceableFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS LOW. R&R EVAC SLIDE ASSY PER MM.SDR SWAA002675Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA002668Slide · out of positionDURING SCHEDULED SERVICE CHECK, FOUND BOTH REAR SLIDES GAUGES UNREADABLE. REPOSITIONED SLIDE ASSY'S PER MM.SDR UPS00834551Slide · inoperativeINSPECTION TYPE:N/A ESCAPE SLIDE INOP REFERENCE M205259 ***SUPPLEMENTAL MRR*** R/R EVACUATION SLIDE & CONTAINER PER M/M 25-62-00. OPS CK NORMAL IN GERT BAR. THIS CLEARS M 205259. PLACARD REMOVED.SDR SWAA002630Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA002628Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA002627Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA002610Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002591Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. READJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA002592Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED EVAC SLIDE ASSY PER MM.SDR SWAA002600Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. READJUSTED EVAC SLIDE ASSY PER MM.SDR F3LA200000263Slide · dischargedPRIOR TO DEPARTURE, FLIGHT CREW REPORTED R-2 DOOR SLIDE PRESSURE LOW. REPLACED R-2 DOOR SLIDE.SDR SWAA002593Slide · out of adjAFT ENTRY DOOR EMERGENCY EVAC SLIDE ASSY OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR F3LA200000262Indicator · out of positionUPON ARRIVAL, MAINTENANCE REPORTED R-2 DOOR SLIDE INDICATOR NOT IN VIEW. REPLACED R-2 DOOR SLIDE.SDR SWAA002571Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA002559Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE PARTIALLY OUT OF CONTAINER. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA002552Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR EVAC SLIDE PRESS INDICATOR LOW. R&R SLIDE ASSY PER MM.SDR 0004406614Slide · rupturedDURING SLIDE SHOP TEST AT OPERATING PRESSURE, INFLATABLE FAILED AT LOWER TUBE OF GLUED SEAM. SLIDE WILL BE OVERHAULED AND RECEIVE A NEW INFLATABLE.SDR SWAA002541Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EVAC SLIDE PRESSURE IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002537Battery · dischargedAFT LOWER EMERGENCY FLASHLIGHT INOP. R&R FLASHLIGHT BATTERY PER MM.SDR SWAA002535Slide · out of positionAFT SERVICE DOOR EVAC SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002534Slide · out of positionAFT SERVICE DOOR EVAC SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002533Slide · unserviceableDURING SCHEDULED 1/4D CHECK, FOUND AFT SERVICE DOOR EVAC SLIDE PRESSURE INDICATOR LOW. R&R SLIDE ASY PER MM.SDR SWAA002526Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND BOTH FWD DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. READJUSTED EVAC SLIDE ASSY PER MM.SDR USAAD00184Bottle · dischargedMCO - THE TAILCONE SLIDE INFLATION BOTTLE PRESSURE WAS LOW. MAINTENANCE REPLACED THE TAILCONE SLIDE ASSY. (M)SDR SWAA002522Slide · out of positionAFT GALLEY SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002519Slide · unserviceableDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY WORN. R&R EVAC SLIDE ASSY PER MM.SDR SWAA002518Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002506Slide · unserviceableDURING SCHEDULED A2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE IND SHOWS LOW PRESS. R&R SLIDE ASSY PER MM.SDR UPS00834518Girt Bar · looseINSPECTION TYPE:N/A GIRTH BAR ON MAIN ENTRY DOOR WILL NOT CONNECT REPOSITIONED SLIDE AND CONNECTED BARSDR SWAA002508Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA002493Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002478Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND BOTH AFT DOOR EMERGENCY EVAC SLIDE GIRT BAR ASSYS OUT OF ADJUSTMENT. READJUSTED SLIDE ASSYS PER MM.SDR SWAA002481Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.
Back to JASC 2565