N1217A
Service difficulty reports · 227
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 = 'N1217A' 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 = 'N1217A' 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 UIEA2018081601716Structure · dentedLOCATED 2EA DENTS AT FUSELAGE STA 618, FWD CARGO DOOR CUTOUT AFT LWR SIDE BTWN 32R-33R. WORK ACCOMPLISHED ON FAS EA 18175-PI & EA 18175 IR.SDR UIEA2018081601715Controller · failedNR 2 ENG PRV CONTROLLER FAILED. PNUEMATIC HEALTH CHECK (PRESS NOT BTWN 47.65 AND 90 PSI. R&R NR 2 ENG PRV CONTROLLER OP & LK CHECK SATISFACTORY IAW AMM 361119 AND 710000. PASSED CHK PSI TASK CARD 6736A005-2.SDR UIEA2018081601717Bulkhead · crackedEMPENAGE STA 1809.5 BULKHEAD FWD FACE, LEFT HORIZONTAL CHORD LBL 28.5 CRACKED ON LWR SIDE OF CHORD. REPAIRED EMPANAGE STA 1809.5 BULKHEAD FWD FACE, LEFT INNER HORIZONTAL CHORD LBL 28.5 LWR SIDE OF CHORD IAW SRM 53-80-08-2R-10 EO 6753A030 REV 12 FIGURE 7.SDR UIEA2018081601713Fire Loop · out of positionNR 1 ENG FIRE FIRE DETECTION LOWER LOOP IS RUBBING ON LOOP SUPPORT TUBING AT 12:00 POSITION (BIFURCATION AREA BELOW ACCESSORY GEAR BOX). INSTALLED NR 1 ENG FIRE DETECTION LOWER LOOP AND ENSURED THERE IS A PROPER SPACING BETWEEN THE FIRE DETECTION LOOP AND SUPPSDR UIEA2018081601711Fastener · wornNR 2 ENG EXHAUST SLEEVE WEAR PAD NR 5 FROM TOP TO BOTTOM IS LOOSE/MISSING HARDWARE INBD SIDE. REMOVED AND REPLACED HARDWARE AT NR 2 ENG EXHAUST SLEEVE I/B SIDE WEAR PAD NR 5 FROM TOP. DONE IAW AMM70-50-00.SDR UIEA2018081601710Detector · detachedAFT CARGO DET MESSAGE ON EICAS. FOUND DETACHED AROUND 66011644-DC AND RECONNECTED. PERFORMED SATISFACTORY OPS CHECK DONE SWPM 20-20-11 AND AMM 26-11-715.SDR UIEA2018081601708Warning System · activatedAPU FIRE LP2 MESSAGE ON EICAS. REMOVED M686 CLEARED CONDUCTS AND REINSTALLED. PERFORMED SATISFACTORY OP'S CHECK DONE IAW SWPM 20-10-04 AND AMM 26-11-0-715.SDR UIEA2018081601726Skin · dentedLOCATED DENT FUSELAGE SKIN STA 1450, STR 49R-20R. COMPLIED WITH FAS EA 18174 REV-IR AT FUSELAGE SKIN STA 1450 STR 19R-20R.SDR UIEA2018081601725Frame · crackedMAIN CABIN LT FRAME HAS 0.600 CRACK AT INBD CHORD TRANSITION RADIUS. REPAIRED IAW BSB 76753A0209.SDR UIEA2018081601724Frame · crackedMAIN CABIN LT FRAME BS 903 HAS A 0.6 LONG CRACK AT INBD CHORD TRANSITION RADIUS. REPAIRED IAW EO 6753A038 PART 9.SDR UIEA2018081601723Outflow Valve · faultyOUTFLOW VALVE INDICATION NOT OPERATING SMOOTHLY. TROUBLESHOT OUTFLOW INDICATION IAW SSM 21-31-01. R&R CABIN PRESSURE SELECTOR ASSY & CABIN OUTFLOW VALVE IAW AMM 21-31-03 AND 21-31-01. PERFORMED SATISFACTORY OPS CHECKS IAW AMM 21-31-01 & 21-31-03.SDR UIEA2018081601722Frame · crackedMAIN CABIN FRAME BS 883, STR 20R SIDE INBD CHORD TRANSITION RADIUS HAS A CRACK 0.600 LONG. REPAIRED IAW BSB 53.40209 FIG10.SDR UIEA2018081601720Frame · crackedMAIN CABIN RT FRAME BS 903 HAS A 0.400 LONG CRACK AT INBD CHORD TRANSITION RADIUS. REPAIRED IAW BSB 53A0209 FIG18.SDR UIEA2018081601719Skin · dentedLOCATED 2EA DENTS AT FUSELAGE SKIN STA 1376, 23R-24R. COMPLIED WITH FAS EA 18178-REV AT FUSELAGE SKIN STA1376, BTWN STA 23R-24R.SDR UIEA2018081901745Warning System · false activationLT SIDE WINDOW, MSG CLEARED. C/W QRH, 10 MIN LATER TURNED AND LEFT LT SIDE WINDOW SWITCH OFF. PER QRH PERFORMED OPS CHECK OF FLIGHT COMPARMENT WINDOW ANTI ICE SYSTEM IAW AMM 30-41-00. OPS CHECK GOOD, NO DEFECTS NOTES AT THIS TIME.SDR UIEA2018071701500Warning System · false activationAPU FAULT ON START UP AFTER LANDING. SUSPECT COLD SOAK. RAN APU SEVERAL TIMES ON GROND IAW AMM 49-11-00 LOADED AND UNLOADED, OPS CHECK OK. APU COLD SOAK REQUIRED IN ORDER TO CONFIRM PROPER OPERATION IN FLT (COLD SOAK START).SDR UIEA2018071301458Status Message · false activationCABIN ALTITUDE AUTO 1 STATUS MESSAGE ON LANDING. PERFORMED BITE CHECK IAW FIM 21-31 FT 803. FAULT CLEARED WITHOUT RETURNING.SDR UIEA2018071601471Warning Message · false activationCABIN ALT AUTO 1 STATUS MSG. PERFORMED BITE TEST OF AUTO 1 CABIN PRESSURE CONTROLLER , NO FAULTS NOTED ON CONTROLLER, NO FAULTS NOTED AT THIS TIME AS PER AMM 21-31-00.SDR UIEA2018071201444Unknown · malfunctionedAFTER LANDING APU WOULD NOT START, 3 ATTEMPTS FAILED. PERFORMED APU BITE CHECK IAW AMM 49-61-05/201, APU STARTING 49-11-00-802-002, OPS CHECKED GOOD.SDR UIEA2018070901386Warning System · false activationCTR RT FUEL PUMP EICAS MESSAGE ON TAKE OFF ROLL. REJECTED T/O. TRANSFERRED FUEL TO WINGS IAW AMM 28-26-00 ACCOMPLISHED. OPS CHECK ON CENTER PUMP IAW AMM 28-22-00 OPS CHECK GOOD AT THIS TIME.SDR UIEA2018062701275Starter · inoperativeAPU COLD SOAK START UNSUCCESSFUL AFTER 3 ATTEMPTS SAT -50, FL 370. REMOVED AND REPLACED APU STARTER AS PER AMM 49-41-01. OPS AND LEAK CHECK OK.SDR UIEA2018062401226Sliding Window · scratchedRT NR 2 WINDOW HAS SCRATCHES IN LINE OF SIGHT. REMOVED AND REPLACED RT NR 2 SLIDING WINDOW IAW AMM 56-11-02-004-001 AND 56-11-02-404-026. ALL OPS CHECKS AND ADJUSTMENTS GOOD.SDR UIEA2018061401158Status Message · false activationCABIN ALT AUTO 1 STATUS MESSAGE DISPLAYED. PERFORMED BITE CHECK ON CABIN ALT AUTO - 1 CONTROLLER UNIT IAW AMM 21-31-01. NO FAULT FOUND ON THE CONTROLLER.SDR UIEA2018051400893Idg · inoperativeRIGHT IDG INOPERATIVE. REMOVED AND REPLACED THE IDG IAW AMM 24-11-01, AND AMM 24-22-02.SDR UIEA2018042700813Idg · inoperativeNR 2 GENERATOR INOPERATIVE EICAS MESSGAE, NO RESET. NNC COMPLETE. REMOVED AND REPLACED THE IDG IAW AMM 24-11-01. PERFORMED A LEAK AND OPS CHECK IAW AMM 24-11-0.SDR UIEA2018041800733Tube · cloggedDUCT PRESSURE TO LOW FOR START, APU RUNNING, PACKS OF 22PSI ONCE STARTER ENGAGES DROPS TO 8 PSI, N2 MOTORS TO LESS THAN 10%. PERFORMED FIM 49-11 FAULT TREE 977, FOUND DEBRIS IN THE SURGE CONTROL VALVE SUPPLY TUBE. REMOVED THE DEBRIS, NO FURTHER FAULTS FSDR UIEA2018040300521Start Valve · stuckRIGHT ENGINE START VALVE STUCK OPEN. REMOVED AND REPLACED THE NR 2 ENGINE START VALVE IAW AMM 80-11-02, LEAK CHECKED OK.SDR UIEA2018040200512Warning Message · false activationAFT CABIN TEMP EICAS MESSAGE. PERFORMED A BITE CHECK OF THE ZONE TEMP CONTROLLER IAW AMM 21-61-03, NO FAULTS NOTED.SDR UIEA2018033000491Warning Message · false activationAPU FAULTED. PERFORMED AN APU BITE IAW FIM 49-11, FAULT TREE 958, NO DEFECTS NOTED. PERFORMED AN APU OPS CHECK IAW AMM 49-11-00 TWO TIMES, NO FAULTS NOTED, OPS CHECKED GOOD.SDR UIEA2018040200511Relay · failedLT AFT BOOST PUMP EICAS MESSAGE. REMOVED & REPLACED THE GFI RELAY IAW SWPM 20-30-00. PERFORMED AN OPS CHECK IAW AMM 28-22-00, OPS NORMAL.SDR UIEA2018032900487Starter · failedLEFT ENGINE DID NOT START. REMOVED AND REPLACED THE STARTER ASSY IAW AMM 80-11-01. OPS CHECKED OK.SDR UIEA2018032400457Warning Message · false activationAPU FAULT EICAS MESSAGE ON TWO START ATTEMPTS AFTER LANDING. EGT NEVER ABOVE 775 AND RPM NEVER ABOVE 28. UNABLE TO DUPLICATED START NORMAL IAW AMM 49-21-00.SDR UIEA2018031600419Valve · failedAPU BLEED AIR DROPS TO 6 PSI WITH PACKS ON. REMOVED AND REPLACED APU VALVE IAW AMM 36-11-10. OPS CHECK GOOD. REMOVED AND REPLACED FLOW MODULE SERIAL 2023, PART 490050 IAW AMM 49-53-00 OPS CHECKS GOOD.SDR UIEA2018031100363Apu · faultedAPU FAULT, NO START. ACCOMPLISHED AN OPS CHECK IAW AMM 49-11-00, AND ACCOMPLISHED AN ECU CHECK IAW AMM 49-61-05. RAN APU, CHECKED NORMAL, NO FAULTS.SDR UIEA2018022300267Light · inoperativeRIGHT ENGINE SPAR VALVE LIGHT INDICATION INOPERATIVE. R & R THE RT SPAR VALVE LIGHT ASSY, OPS CHECKED OK.SDR UIEA2018022000259Valve · unknownRIGHT ENGINE SPAR VALVE FAILED TO ILLUMINATE UPON ENGINE START. PERFORMED OPS CHECKS OF ENG SPAR VALVE IAW 28-22-11 AND RAN ENG AT IDLE IAW AMM 71-00-00. OPS CHECK NORMAL AT THIS TIME. INBD FLT CREW ALSO REPORTED OPS CHECKS NORMAL. THIS CLEARS MDDR. DISPATCH SDR UIEA2018021300212Radar · unknownWEATHER RADAR INOPERATIVE. RESET THE CIRCUIT BREAKERS, PERFORMED OPS CHECKS IAW AMM 34-43-00, OPS CHECKED GOOD, NO DEFECTS NOTED AT THIS TIMESDR UIEA2018020500172Boot · tornAPU SURGE BLEED VALVE BOOT TORN. REMOVED AND REPLACED THE BLEED VALVE BOOT IAW AMM 49-53-01.SDR UIEA2018020500173Igniter · fouledAPU IGNITER PLUG FOULED. REMOVED AND REPLACED THE IGNITER PLUG IAW 49-41-02. OPS CHECKED NORMAL.SDR UIEA2018020500174Seal · tornNR 2 ENGINE FAN CASE SEAL TORN ABOUT 4 INCHES AT THE 6 O'CLOCK POSTION. REPAIRED THE FAN CASE SEAL IAW AMM 72-33-00.SDR UIEA2018020500175Priority Valve · malfunctionedRIGHT PRSOV WILL NOT INDICATE OPEN. REMOVED AND REPLACED THE PRSOV IAW AMM 36-11-09.SDR UIEA2018020500176Pressure Switch · faultedLEFT PRSOV LOW PRESSURE SWITCH FAULTY. REMOVED AND REPLACED THE SHUTOFF VALVE IAW AMM 36-11-09. OPS CHECKED NORMAL.SDR UIEA2018020500177Priority Valve · malfunctionedLEFT PRV DOES NOT INDICATE OPEN. REMOVED AND REPLACED THE VALVE AND OPS CHECKED NORMAL IAW AMM 36-11-18.SDR UIEA2018020500178O-Ring · wornHIGH PRESSURE CONTROLLER O RING AT FITTING IS WORN(<P>REMOVED AND REPLACED O RING AT ENG 2 HPSOV. OPS CHECK NORMAL IAW AMM 36-11-08</P>)SDR UIEA2018020500179Bolt · missingFOUND A BOLT AND BUSHING MISSING ON THE NR 2 ENGINE 11TH STAGE COOLING AIR TUBES AT THE 4 O'CLOCK POSITION. INSTALLED THE BOLT IAW AMM 75-24-03.SDR UIEA2018011200060Pressure Switch · failedRIGHT ENGINE TAI VALVE STATUS MESSAGE IN FLIGHT WITH ENG ANTI-ICE ON. REPLACED THE PRESSURE SWITCH S525. CHECKED GOOD IAW AMM 30-21-01, & 30-21-03.SDR UIEA2018010300007Warning Light · false activationAFT CABIN TEMP INOPERATIVE. HTC AND MESSAGE RESET IN FLT, NO FAULTS ON TEMP CONTROL BOX IAW AMM 21-51-00.SDR UIEA2017103102146Terminal · brokenDURING A TEST, THE LT PRV FAILED, TROUBLESHOT IAW WDM 36-11-61. FOUND WIRE W3312-007-18 BROKEN OFF AT TERMINAL. REPLACED THE TERMINAL TO WIRE STUD.SDR UIEA2017102502004Radar · malfunctionedLEFT RADAR STABILIZATION PRESENTS STREAKS DURING CRUISE AND DESCENT. RADAR CHECKED NORMAL IAW FIM 34-43 FAULT TREE 805. CHECKED BOTH LT AND RT TRANSCEIVERS, NO FAULTS FOUND.SDR UIEA2017092601875Control Valve · failedRIGHT PACK TEMP EICAS ILLUMINATED INTERMITTENTLY DURING CLIMB OUT, LIGHT OUT IN STANDBY. REMOVED AND REPLACED THE RT ACM TEMP CONTROL VALVE OPS & LEAK CHECKED GOOD IAW AMM 21-51-12.
Back to N1217A