N972UY
Service difficulty reports · 123
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
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 n_number = 'N972UY' AND registry_match = 'registration' 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 n_number = 'N972UY' AND registry_match = 'registration' 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 AALA201812179003Slide · faultyAIRCRAFT WAS IN BASE MAINTENANCE. SLIDE COVER WILL NOT FIT OVER THE SLIDE. REPLACED SLIDE PER JOB CARD 26L00025010.SDR AALA201810059018Light · unknownEMERGENCY EXIT LIGHTS RANDOMLY COME ON, RESET AND COME ON AGAIN. CIDS POWER UP TESTED OK IAW TSM 23-73-00-810-937A. PERFORMED AN OPS CHECK OF THE EMERGENCY LIGHTS, TESTED OK IAW AMM 33-51-00-710-001A. NO FAULT FOUND.SDR AALA2018080329008Bottle · low pressureR4 DOOR BOTTLE PRESSURE LOW. SERVICED THE DOOR ASSIST BOTTLE IAW AMM 52-13-00SDR AALA201807109002Bottle · low pressureAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT REPORTS 4R CHECK DOOR PRESSURE ON CID'S PANEL. SERVICED AS REQUIRED AMM 25-62-00.SDR AALA201807109007Floorboard · delaminatedTHE AIRCRAFT WAS GROUNDED. CARGO FLOORBOARD 151PF DELAMINATED. REPLACED CARGO FLOORBOARD PER AMM 53-42-14.SDR AALA201806019006Bottle · low pressureR4 DOOR PRESSURE LOW. SERVICED R4 DOOR ASSIST BOTTLE IAW AMM 52-22-14.SDR AALA2018053099033Lever · unsecureL3 DOOR ARMING LEVER LOOSE. SECURED THE DOOR ARMING LEVER.SDR AALA201803199010Lever · brokenR2 DOOR DISARM-ARM LEVER WAS FOUND BROKEN. REPLACED THE R2 DOOR ARM-DISARM LEVER IAW EO 5216E175. AIRCRAFT WAS GROUNDED.SDR AALA201712149026Bottle · low pressureAIRCRAFT NOT GROUNDED. CREW REPORTED 4R DOOR ASSIST BOTTLE PRESSURE LOW. MAINTENANCE SERVICED DOOR 4R ASSIST BOTTLE PER TASK 52-13-14-200-001-A AND SUB TASK 52-10-00-614-001-A. OPERATIONS CHECK NORMAL AND INDICATION NORMAL.OKAY FOR SERVICE.SDR AALA201707199022Cylinder · low pressureR4 DOOR SHOWS CHECK SLIDE PRESSURE ON FLIGHT ATTENDANT DOOR PANEL. SERVICED THE R4 DOOR ASSIST BOTTLE TO PROPER PRESS IAW AMM.SDR AALA201706299005Shrader Valve · leakingCIDS INDICATED CHECK DOOR PRESSURE FOR THE R4 DOOR. PRESSURE CHECKS GOOD AND INDICATION REMAINED FOR ENTIRE FLIGHT. REPLACED SHARDER VALVE.SDR AALA201706289007Bottle · low pressureCIDS SHOWS CHECK DOOR PRESSURE WITH ACFT DEPRESSURIZED AND R4 IS ARMED WITH DOOR GUARD AND CONFIRMED ON ECAM. R4 DOOR ASSIST BOTTLE PRESSURE LOW. SERVICED TO FULL.SDR AALA201705319014Lock · out of adjustLOCKING MECHANISM OUT OF ADJUSTMENT. LOCK/UNLOCK FLAGS DO NOT DISPLAY CORRECTLY. ADJUSTED LOCK/UNLOCK FLAG MECHANISM IAW AMM 52-22-00 OPS CHECKED NORMAL.SDR AALA201705309027Cylinder · low pressureR4 DOOR DISPLAYS LOW PRESSURE. SERVICED THE R4 DOOR EMERGENCY N2 CYLINDER IAW AMM 52-10-00 -614-001-A TO SERVICEABLE PRESSURE, NO LEAKS FOUND.SDR AALA201705109004Handle · looseFLIGHT ATTENDANT REPORTED THE L3 DOOR ARMING HANDLE LOOSE. TIGHTENED ARMING HANDLE.SDR AALA201704179034Lever · brokenSLIDE ARMED LEVER AT THE L3 DOOR IS BROKEN OFF. REMOVED AND REPLACED ARM/DISARM MECHANISM.SDR AALA201703249003Cylinder · low pressureR4 DOOR SLIDE BOTTLE HAD LOW PRESSURE. DOOR DAMPER CYLINDER WAS LOW, SERVICED TO GREEN BAND.SDR AALA201702249001Light · inoperativeEMERGENCY LIGHT 18L INOPERATIVE. REPLACED LIGHT IAW AMM.SDR AALA201702029003Lens · missingL4 EMERGENCY EXIT DOOR COVER MISSING. REPLACED EMERGENCY.LIGHT LENS.SDR AALA201611309015Cover · missingMISSING EMERGENCY LIGHT COVER AT SEAT 22D. REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-19-04.SDR AALA201611199002Battery · dischargedAFT MEGAPHONE INOP. R&R BATTERIES FOR AFT MEGAPHONE, OPS CK'S NORMAL. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201608089008Bottle · low pressureFLIGHT ATTENDANT PANEL DOES NOT INDICATE AFT R4 DOOR IS ARMED. COCKPIT INDICATION NORMAL. MAINTENANCE FOUND THE AFT RIGHT ESCAPE SLIDE BOTTLE PRESSURE LOW (OUT OF GREEN BAND) AND REPLACED THE SLIDE ASSEMBLY IAW TASK CARD 26L00025010. AIRCRAFT GROUNDED.SDR AALA201601069009Sensor · defectiveAIRCRAFT WAS GNDED. JUST AFTER TAKEOFF THE CREW RECEIVED AN ECAM MSG FOR A NOSE WHEEL STEERING FAULT & ELECTED TO CONTINUE. DECLARED EMER & LANDED WITH NO INCIDENTS. THE ACFT EXITED THE RUNWAY & WAS TOWED TO THE GATE. REPLACED STEERING FEEDBACK CONTROL SEN
Back to N972UY